Since the inception of the idea of metadata management in SAS 9, administrators have always had the ability to export their metadata. In SAS 9.2, an API was released to provide a way for administrators to script and even automate the export/import process. Now in SAS 9.3, the ability to archive and store SAS metadata export packages (.spk) in third party version control applications is surfaced through SAS Data Integration. This functionality currently integrates with Concurrent Versions System (CVS) server and Apache Subversion (SVN) servers.
In this article we will discuss the steps required to leverage this new functionality with CollabNet Subversion Edge 2.1.
Apache Subversion Installation
Firstly, you will need to have an Apache Subversion server up and running. CollabNet Subversion Edge 2.1 was used because of its simplicity to install and configure on Windows(32 and 64 bit) . The complete software stack is available for download at the following URL:
Here is some documentation on CollabNet Subversion Edge 2.1:
Once you have the installation package downloaded to your server, double click the executable.
The installer will appear, select “Next”:
Take the time to read the “Readme file”, when finished click “Next”:
Select a folder for the installation, the default can be used or browse to your location and click “Next”:
The installation is now ready to install, click “Install” to begin:
The installation will proceed:
The installation will have command prompts appear:
If the installation is successful, the following window will appear, untick the “View readme file” and click “Finish”:
Apache Subversion Configuration
Enter the following address into a web browser:
<CSVN Installation Directory>\launch.html
The launch page will appear, click on the hyperlink to log on:
The login page will load; the default username and password are “admin”/”admin”:
Once logged in the status page will load showing you the health of the SVN server. A new repository is required for storing packages, click on the “Repositories” tab:
Click “New Repository”, then enter a name, i.e. “SAS_SVN” and then click “Create”:
The repository will be created and the properties will be shown. A user to connect to the repository must be created, click on the “Users” tab:
On the “Users” tab, the admin user is visible, click “New user”:
Enter the details for the user and select the “ROLE_USER” under “Roles Granted”. Click “Create” once the settings are complete:
The new user will be shown in the User List:
Now that the user has been created, the connection to the repository can be tested. On the menu click the “Repositories” tab. From the “Repository List”, click the repository that was created, “SAS_SVN”.
After clicking on the repository a logon prompt will be presented, enter in the user name and password of the user that you created in the previous instruction and click “OK”.
The following (or similar) information should appear in the browser if the configuration has been done correctly. Now the client must be configured.
Configuring SAS Data Integration Studio
Install third party version control client
SAS Data Integration Studio requires that a third party version control client be installed on the same client machine. Tortoise SVN is a common client used throughout the industry. You can download the client for free from the following link: http://tortoisesvn.net/downloads.html
Once you have downloaded the appropriate version (x86 or x64), begin the installation by double clicking the installation msi.
Follow the standard prompts:
Choose to install via the custom setup. Ensure that you select the option to install the command line client tools. Click “Next”.
Click the “Install” button, note that you will need administrator privileges id
When the client is successfully installed the follow window will appear. Click “Finish”.
Note the directory which the client was installed into. The default location is “C:\Program Files\TortoiseSVN” and the executables required are located inside of the “bin” folder. This location will be required when setting up the SAS Data Integration Studio.
Enable the appropriate SAS java plug-‐ins in DI Studio
SAS DI Studio ships with two different plug-‐ins for integration with version control, one for accessing SVN servers and the other for CVS. In order to configure SAS Data Integration Studio to use the SVN plug-‐in, the CVS plug-‐ins must be moved out of the “Program Files\SASHome\SASVersionedJarRepository\eclipse\plugins\” location. First locate the following directories:
Create an “Archive” folder under “Program Files\SASHome\SASVersionedJarRepository\eclipse\plugins\”
Cut the previous directories and paste them into the Archive directory:
Enable and test connection to version control repository
Start SAS DI Studio and login as the user that you created in SVN (sasdemo). From the menu bar select Tools -‐> Options…
The following properties window will appear, select the “SVN Plug-‐in” tab. In this tab, the following information will need to be provided:
- Local Option –> Program Path: This is the location that the version control software installed. Specifically referencing the .exe used to run the client. C:\Program Files\Tortoise SVN\bin\svn.exe
- Local Option –> Local Root Path: This is the location is a temporary location where a local version of the repository will be stored.
- Location –> Server: This is the server name where the version control repository is located, a fully qualified name (including domain) or ip addresss may be required.
- Location -‐> Repository: The value will be /svn/<name of repository>.
- Authentication -‐> Username: The username that was created during configuration.
- Authentication -‐> Password: The password that was given to the user above.
- Connection Type -‐> Port: The port used for connections is 80.
- Connection Type -‐> Port: Select HTTP from the dropdown list.
The following dialog box will appear.
If the configuration has been done correctly the following dialog box will appear. Click ‘OK’ and enjoy your newly configured DI Studio Client with Version Control enabled.
This article was originally posted 27Jan2012 at http://www.scorpiosoftware.com.au/2012/01/configuring-version-control-in-sas-9-3-enterprise-data-integration-server/