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