BookmarkSubscribeRSS Feed
AllanBowe
Barite | Level 11

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?)

 

 

/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs
4 REPLIES 4
r2liquibase
Calcite | Level 5

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

AllanBowe
Barite | Level 11

I sent a mail - thanks for the follow up!

/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs
VincentRejany
SAS Employee
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
AllanBowe
Barite | Level 11
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
/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1649 views
  • 2 likes
  • 3 in conversation