Configuring SPE database connections

Design Studio can test-run maps and deploy artifacts to the Standards Processing Engine (SPE). Use the Design Studio preferences to configure the connection to an SPE database, or use the default SPE database.

1. Start Design Studio.
2. Click Window > Preferences.
3. In the navigation pane, expand Transformation Extender and click Standards Processing Engine.
4. In the Repository section, click Manage to add, edit, or delete a database connection.
   Note: You cannot edit or delete the default database connection.
5. In the Name field, enter a label for the database connection, for example, "Test" or "Production." (The Name field displays DEFAULT when the SPE default database connection is in effect.)
6. In the URL field, enter either:
   • The URL of the SPE database in JDBC format. For example:

     jdbc:derby://localhost:1527/spe

     jdbc:oracle:thin:@oracledb6.acme.com:1527:ora11

     jdbc:db2://db2db9.acme.com:50000/spetest

   • The URL of a configuration file that contains the JDBC/OpenJPA connection parameters of the SPE database. For example:

     file://C:/oracledb.cfg

     file://C:/SPEInstall/dbprops_SQLServer2012.txt

7. Specify the SPE database user name and password in one of the following ways:
   • Enter the information in the User Name and Password fields.
   • Include the user name and password in the URL for the SPE database. For example:

     jdbc:derby://localhost:1527/spe;user=admin1;password=sec12cde

   • Include the user name and password in the URL by specifying the {dbuser} and {dbpswd} variables. For example:

     jdbc:derby://localhost:1527/spe;user={dbuser};password={dbpswd}

     With this configuration, Design Studio prompts you to enter a user name and password each time you test-run a map or deploy an artifact to SPE.
   • Specify the user name and password by specifying the {dbuser} and {dbpswd} variables in the User Name and Password fields. With this configuration, Design Studio prompts you to enter a user name and password each time you test-run a map or deploy an artifact to SPE.
8. In the Driver Name field, enter the name of the JDBC driver that connects to the SPE database.
9. Optional: In the Schema Name field, enter the name of the SPE database schema.
10. Click one of the following:

    Update

    To update an existing SPE database connection or add a new one.

    Delete

    To delete an existing SPE database connection.

    Finish

    To update or add an SPE database connection and close the Manage Repository window without a confirmation prompt.

    Close

    To cancel your changes and close the Manage Repository window.