1. From the DataDirect program group, start the ODBC Administrator and click either the User DSN, System DSN, or File DSN tab to display a list of data sources.
User DSN: If you installed default DataDirect ODBC user data sources as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.
If you are configuring a new user data source, click Add to display a list of installed drivers. Select the appropriate driver and click Finish to display the driver Setup dialog box.
System DSN: To configure a new system data source, click Add to display a list of installed drivers. Select the appropriate driver and click Finish to display the driver Setup dialog box.
File DSN: To configure a new file data source, click Add to display a list of installed drivers. Select the driver and click Advanced to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.
The General tab of the Setup dialog box appears by default.
Note: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional, unless noted otherwise in this book.
2. On the General tab, provide the following information; then, click Apply.
Data Source Name: Type a string that identifies this data source configuration, such as Accounting.
Description: Type an optional long description of a data source name, such as My Accounting Database.
Host Name: Type the host name of the Oracle Service Cloud site to which you want to connect. Do not include the internet protocol (such as http:// or https://) in this value. For example, mysite.custhelp.com.
Interface Name: Type the name of the Oracle Service Cloud interface to which you want to connect.
Provide the requested information for all other options on the General tab; then, click Apply to configure the data source.
3. On the SQL Engine Tab, provide the required information; then, click Apply. The SQL Engine Tab has the following required connection option:
JVM Classpath: Type a string that specifies the full path to the rightnow.jar file included in this installation.
User DSN: If you installed default DataDirect ODBC user data sources as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.