Configuring the External Database Connection

If you are using SQL Server connection, you must use the With SQL Server authentication using a login ID and password entered by the user option.

  To configure the Strategic Finance Server connection to the export database:

  1. Open the Administrator.

  2. Select Server then Open to select the server.

  3. Select Databases or View then Databases.

  4. Select Database then External Database.

  5. From HSF Database, select the database to connect to the external database.

  6. From Connection Type, select Export.

  7. In OLEDB Data source, enter the Data Source Name.

  8. In User ID, enter the user ID used to access the relational database.

  9. In Password, enter the schema password.

  10. In Rule Set Name, enter a rule set name.

  11. Optional: In E-mail Addresses, enter comma-separated E-mail addresses of individuals to notify if exports fail.

  12. To export entities, select Database Connectivity Enabled .

  13. Click OK.

    The connection is created and tested.