Create an External Connection to Oracle
Create a connection to an external Oracle Server database. Then, you can map a Business Object to the connection, and import data into the Business Object.
To create an external connection to an Oracle Server Database:
- Open or create a Blueprint.
- Select Managers > External Connections to open the External Connections Manager.
- Select Create New to open the External Connection Wizard.
- On the Login options page, select the Use Trusted Agents check box if you use the Trusted Agents feature and you want to control how the system logs in to the external data source.
- Select one of these options, and then select
Next.
- Any Trusted Agent Group: Select to allow any group to handle requests for this external connection.
- Trusted Agent Group: Select a specific group to handle requests for this external connection.
- On the Data Source page, select Oracle.
- On the
Select Net Service Name page, provide the full
string containing the service name.
(DESCRIPTION=(ADDRESS=(protocol_address_information))(CONNECT_DATA=(SERVICE_NAME=service_name)))
- On the
Login Options page, if the database requires
login information, select the
Login Required check box and either:
- Windows Authentication: Uses the
stored Windows credentials (user name and password) for authentication.
When Cherwell Services use this connection, the account under which the Cherwell Application Service is running is the account whose credentials are used to connect to the database.
- User ID and Password: Provide a user
ID and password.
The account must have select rights for each table that is imported or linked to CSM. If CSM is allowed to update data in the database, this account must also have insert and update rights.
- Windows Authentication: Uses the
stored Windows credentials (user name and password) for authentication.
- Select Next.
- On the
Database Owner or Schema page:
- Select an option from the drop-down list or provide a database owner or schema. This field should be pre-populated. Not all databases have this concept. If implemented and CSM is able to read the available owners, then they are listed in the drop-down list. If not, provide the owner name. If unsure, provide the default dbo.
- Select Next.
- On the
Pooling Options page, select a Connection
Pooling option for the database, and select
Next:
- Select the Use default pooling options radio button.
- Select the
Customize the pooling options radio button,
and then provide the minimum and maximum pool size.
To improve performance, set the maximum pool size to three times the number of concurrent CSM licenses that are used in your organization. You may need to adjust this value, depending on usage of your system.
- On the
Connection name page, provide a name and
description (optional) of the database connection, and then select
Next.
The Connection String page opens, displaying the connection string that is used to connect to the database. Modify the connection string, if needed. Many examples of connection strings can be found at www.connectionstrings.com.
- Select Test Connection to verify the connection to the server/database. Text appears next to the button confirming the connection is successful.
- Select Finish. A connection now exists to the Oracle database.
- Publish the Blueprint (File > Publish Blueprint) to commit the changes, or save the Blueprint (File > Save Blueprint) to continue making other changes.