Connecting to External Databases

  To create external database connections:

1. In Administrator, select Databases.

2. Select Database then External Database.

3. In HSF Database, select a database.

4. In Connection Type, select an option:

   • Export — Select to connect to a database that will house Strategic Finance data that you export

   • Import — Select to connect to a database that will house data you will import for use in Strategic Finance

   • Extended Analytics — Select to connect to an Extended Analytics (Essbase) database.

     See Creating Extended Analytics Rule Sets and Exporting to Essbase.

5. In Data source , either enter the ODBC datasource name or the connection string, as follows for the Extended Analytics database:

   Table 3. Connection Syntax

   Database	Connection Strings
   SQL Server	Provider='SQLOLEDB';Server='{hostname}';Database='database name'
   Oracle	Provider='OraOLEDB.Oracle';Data Source='{SID} or: Provider='OraOLEDB.Oracle';Data Source='{database name}'; HOST='{hostname}' Note: Do not use the Initial Catalog variable
   IBM DB2	Provider='IBMDADB2';Database='{database name}';Hostname='{hostname}';Protocol=TCPIP; Port=50000;QUOTED_IDENTIFIER=off or: Provider='IBMDADB2';Data Source='{database name}';Persist Security Info=True;QUOTED_IDENTIFIER=off;{hostname}, can be an IP address, un-qualified host name or fully-qualified host name

6. In User I.D., enter the user name or owner for the destination database.

7. In Password, enter the password for the target database.

8. In Rule Set Name, enter the Rule Set to transfer.

9. In Email Addresses , enter the email addresses to send transfer error messages.

10. Select Database Connectivity Enabled to enable the database connection.

11. Click OK.