![]() | ![]() | ![]() | ![]() |
Note: This SAS Note currently replaces "Reconfiguring the SAS Content Server to Share the Database Used by SAS Shared Services" in the SAS® 9.2 Intelligence Platform: Web Application Administration Guide, Third Edition.
Beginning with the third maintenance release for SAS® 9.2, SAS Content Server supports database persistence. By default, the SAS Content Server uses the file system for persistence. Generally, you do not need to change this setup. However, in some environments, there might be a compelling need to use a back-end database. In such cases, you can reconfigure the SAS Content Server to share the database that is used by SAS Shared Services.
By default, SAS Shared Services uses the SAS® Table Server. However, you can configure SAS Shared Services to use a different database such as the SAS Threaded Kernel Table Server (TKTS), Oracle, MySQL, Postgres, IBM DB/2, or Microsoft SQL Server.
To migrate the contents of the current SAS Content Server repository to a database repository, download either the JCRCopyRepository.bat or the JCRCopyRepository.sh script file from the Downloads tab. Then place the script file in the SAS-configuration-directory/Web/Utilities directory, and customize the file for your environment. After you customize and save the file, follow the steps below to reconfigure the SAS Content Server so that it shares and uses the same database that is used by SAS Shared Services:
If your server is a Red Hat JBoss Web application server, follow these steps:
This value appears six times within the repository.xml file. You must modify all six instances of the parameter.
Note: If a workspace.xml file exists in the SAS-configuration-directory/Lev1/AppData/SASContentServer/Repository/workspaces/default directory on the middle-tier server, it will contain two instances of the same parameter. You must also modify those two instances as well with the value <param name="url" value="java:sas/jdbc/SharedServices"/>.
The directory path should include the list of JAR files. The listed JAR files should be concatenated by semicolons (under Windows) or colons (under UNIX).
The values that you specify for the JDBC URL and for the driver are determined by the type of database that is used in your environment. The following table lists the values for the different types of databases:
| Database | Parameters | Values |
|---|---|---|
| TKTS |
-Dscs.jndi.jdbcUrl |
jdbc:sastkts://host:2171?constring=(DSN=SharedServices) |
| TKTS |
-Dscs.jndi.driver |
com.sas.tkts.TKTSDriver |
|
Oracle |
-Dscs.jndi.jdbcUrl |
For Oracle: jdbc:oracle:thin:@host:1521:orcl For Oracle XE:
jdbc:oracle:thin:@host:1521:xe |
| Oracle |
-Dscs.jndi.driver |
oracle.jdbc.driver.OracleDriver |
| Postgres |
-Dscs.jndi.jdbcUrl |
jdbc:postgresql://host:5432/SharedServices |
| Postgres |
-Dscs.jndi.driver |
org.postgresql.Driver |
| DB2 |
-Dscs.jndi.jdbcUrl |
jdbc:db2//host:50000/database |
| DB2 |
-Dscs.jndi.driver |
com.ibm.db2.jcc.DB2Driver |
| MSSQL |
-Dscs.jndi.jdbcUrl |
jdbc:sqlserver://host1433;DataBaseName=SharedServices;SelectMethod=cursor |
| MSSQL |
-Dscs.jndi.driver |
com.microsoft.sqlserver.jdbc.SQLServerDriver |
| MySql |
-Dscs.jndi.jdbcUrl |
jdbc:mysql://host:3306/SharedServices |
| MySql |
-Dscs.jndi.driver |
com.mysql.jdbc.Driver |
In the command window, navigate to the SAS-configuration-directory/Web/Utilities directory.
Run the JCRCopyRepository script command by providing the complete directory path of the old and new repository directories, as follows:
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise BI Server | z/OS | 4.2 | 9.2 TS2M3 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows XP 64-bit Edition | 4.2 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for x64 | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 4.2 | 9.2 TS2M3 | ||||
| Microsoft Windows XP Professional | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise 32 bit | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise x64 | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium 32 bit | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium x64 | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Professional 32 bit | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Professional x64 | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate 32 bit | 4.2 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate x64 | 4.2 | 9.2 TS2M3 | ||||
| Windows Vista | 4.2 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 4.2 | 9.2 TS2M3 | ||||
| 64-bit Enabled HP-UX | 4.2 | 9.2 TS2M3 | ||||
| 64-bit Enabled Solaris | 4.2 | 9.2 TS2M3 | ||||
| HP-UX IPF | 4.2 | 9.2 TS2M3 | ||||
| Linux | 4.2 | 9.2 TS2M3 | ||||
| Linux for x64 | 4.2 | 9.2 TS2M3 | ||||
| Solaris for x64 | 4.2 | 9.2 TS2M3 | ||||
To migrate the contents of the current WebDAV repository to the database-based repository, use the JCRCopyRepository.bat or the JCRCopyRepository.sh files.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2010-06-09 12:58:04 |
| Date Created: | 2010-04-16 14:45:17 |



