topic Re: Using Liquibase with SAS in SAS Data Management

Using Liquibase with SAS

AllanBowe — Mon, 19 Oct 2020 18:48:37 GMT

Does anyone have any experience, tips or suggestions for using Liquibase to manage SAS tables?

Am guessing an approach would be to use the h2 database, write changes in YAML or XML, and generate DDL in some SAS friendly format (Postgres? SQL Server?)

Re: Using Liquibase with SAS

r2liquibase — Tue, 20 Oct 2020 12:56:29 GMT

I'm on the Liquibase team and I am *very* intrigued by this. I haven't used SAS since my undergrad days, but we'd love to help with this.

I think you're on the right track to manage the underlying database that supports SAS. But, I'm sure there are a ton of gotchas ahead. It's pretty easy to get in touch with someone on the team to ask questions: https://www.liquibase.org/contact.

Thanks!

Robert

Re: Using Liquibase with SAS

AllanBowe — Tue, 20 Oct 2020 13:21:17 GMT

I sent a mail - thanks for the follow up!

Re: Using Liquibase with SAS

VincentRejany — Mon, 02 Nov 2020 10:46:57 GMT

Hi Allan

Would be interested in hearing about the use case. As we are working on SAS Studio it could be interesting to investigate an integration with Liquibase

Re: Using Liquibase with SAS

AllanBowe — Mon, 02 Nov 2020 10:51:15 GMT

Indeed, that would be great. What is really needed is for a java developer to write the requisite connector so that the liquibase control tables could be held as SAS datasets, and the relevant conversions applied.

In the meantime I'm using the H2 database, changesets in YAML, and generating SQL change scripts. Just getting started with it, will write up my approach in the next week or two