topic Re: Anyone using Git for version control of SAS Data Integration Studio 4. in SAS Data Management

Anyone using Git for version control of SAS Data Integration Studio 4.

TestingSAS — Thu, 06 Aug 2015 21:14:20 GMT

I'm looking into bringing version control into our production sas environment.

Anyone have experiences with GIT? I am more interested to know if we have GIT plugin the way we have for CVS and SVN.

thanks in advance

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

pic_sas — Wed, 28 Oct 2015 09:34:30 GMT

Hi,

There isnt any standard SAS Product or Add-in that supports managing DI objects through GIT repository. This feature is currently being discussed and might be a part in some future releases. But as of now - we have to manage it with CVS.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

hamish_at_nab — Wed, 13 Apr 2016 00:58:36 GMT

The source code for the SVN and CVS plugins are availble here: http://support.sas.com/rnd/gendoc/versioncontrol/43/en/

In theory these can be used to create a plugin for any other version control system (eg git). In practice I don't think it will be something I get to on the project I'm assigned to 😞 If you do get to it, please share 😄

Another alternative could be to use a hybrid of both using DIStudio to commit to SVN then scripting a "pull" from SVN into GIT.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

paulkaefer — Mon, 28 Nov 2016 16:11:06 GMT

Did anyone write a plugin, or find one that someone else developed?

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

Hoki — Wed, 30 Aug 2017 05:36:47 GMT

Has there has been any progress on official GIT support for SAS DI Studio since two years ago?

I had a look at creating a GIT plugin using JGIT to hook into your plugin interface.

However after reading through your documentation and examining your source code for the SVN/CVS implemetation.

I can see possible problems with the file format for the metadata..

The current persistence/export file format you are using for your source control, looks to be the standard spk export file format.

Which is a compressed binary archive file, holding subfiles(xml, properties, ...) describing the metadata exported.

Merging and version difference analysis is difficult with binary files.

The xml subfiles (e.g. TransportMetadata.xml) held in the spk are also single lined, instead of pretty print formatted.

Sounds like a minor thing, but it makes it really hard to make sense of things with standard diff tools.

Are there any plans by SAS to define new user readable xml export file formats instead of binary blobs for your SAS DI metadata??

Which makes it practical for your users to use standard source control tools on them.

I have seen other vendors like Oracle do so for their metadata tools.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

Patrick — Wed, 30 Aug 2017 08:30:16 GMT

@Hoki

"Are there any plans by SAS to define new user readable xml export file formats instead of binary blobs for your SAS DI metadata??"

Your .spk is actually a zip archive containing XML's. Use WinZip or the like and open the .spk and you'll see.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

sweroz — Wed, 06 Dec 2017 13:49:52 GMT

Hi,

GIT Plugin for DI-Studio is available now. You can find plugin from "SAS Knowledge Sharing Application (KSA)".

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

paulkaefer — Wed, 06 Dec 2017 14:55:19 GMT

Thanks, @sweroz. Can you share a link to the plugin/KSA? I can't seem to find one.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

sweroz — Thu, 07 Dec 2017 21:14:01 GMT

You can find it here:

Update: took out internal link.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

paulkaefer — Thu, 07 Dec 2017 14:44:50 GMT

@sweroz, I'm not able to access that link... I tried switching "sww" to "www". I feel like this may have happened before. Is this an internal SAS link?

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

sweroz — Thu, 07 Dec 2017 14:48:22 GMT

Yes, it is. If you have access to KSA then search for version control.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

paulkaefer — Thu, 07 Dec 2017 14:50:20 GMT

@sweroz: is the KSA something I can get access to as a non-SAS employee? Or is it a specific product that would depend on what my organization has purchased?

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

AnnaBrown — Thu, 07 Dec 2017 16:33:22 GMT

Hi @paulkaefer,

I just confirmed that yes, this KSA is internal-only. Sorry about that. Also there's still discussion about Git integration internally, but nothing is available as of yet.

Best,

Anna

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

LinusH — Thu, 07 Dec 2017 19:13:00 GMT

Oooops... 🤤

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

manpreetps — Mon, 11 Dec 2017 16:05:59 GMT

Do we have a plugin in SAS DI studio for Gitlab? Appreciate if you can share the link.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

LinusH — Mon, 11 Dec 2017 16:54:17 GMT

As you can read above, no, not a institute supported one for customers.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

ChrisHemedinger — Mon, 11 Dec 2017 17:17:36 GMT

As you might have gleaned, a technician at SAS build an extension as a prototype and shared it internally within SAS. We are looking to see if it is something that can be shared externally. If so, we'll post back.

Such prototypes are often built as proof-of-concept or demos. As such, the quality might not be suitable for production use and the authors might be reluctant to publish as-is. Those caveats apply here.

But as you can see from some of the replies, it is possible to build your own extension based on the source code that SAS supplies. That might be more than you're willing to do at this point.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

manpreetps — Tue, 12 Dec 2017 09:39:06 GMT

Thanks Chris for the quick reply.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

manpreetps — Tue, 12 Dec 2017 09:39:44 GMT

Thanks.

Re: Anyone using Git for version control of SAS Data Integration Studio 4.

AndrewHowell — Tue, 13 Feb 2018 03:44:35 GMT

Chris,

Why not put word out for client sites willing to beta-test? I'm at a site which is keen to use Git not just for source-code control, but also to mange SDLC promotion from Dev-Test-Prod.

I've played with (*.sas) code in versioning software, and am keen to test how it handles (*.spk) metadata packages, inter-object dependencies, etc.

Regards,

Andrew.