skip to main content
Getting Started : Configuring and Connecting on macOS : Configuring a Data Source
  

Try DataDirect Drivers Now

Configuring a Data Source

To configure a data source using the iODBC GUI:
1. Using Finder, open the iODBC Administrator application and click either the User DSN, System DSN, or File DSN tab to display a list of data sources.
*User DSN: If you installed a default DataDirect ODBC user data source 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 data source Setup dialog box appears. If you are configuring an existing data source, the dialog is prepopulated with a list of the connection option attribute-value pairs currently stored in the odbc.ini file. For new data sources, the dialog will be empty.
2. On the Setup dialog, provide keyword-value pairs for the connection options in the following table; then, click OK. To add missing pairs, click the Add button . Then, in the new row, type the attribute name in the Keyword field and the desired valid value in the Value field.
Table 1. Required Connection Options
Keyword
Value
EditionName
Oracle 11g R2 and higher only. The name of the Oracle edition the driver uses when establishing a connection. Oracle 11g R2 and higher allows your database administrator to create multiple editions of schema objects so that your application can still use those objects while the database is being upgraded. This option is only valid for Oracle 11g R2 and higher databases and tells the driver which edition of the schema objects to use.
HostName
The name or the IP address of the server to which you want to connect.
PortNumber
The port number of your Oracle listener. Check with your database administrator for the number.
ServiceName
The Oracle service name that specifies the database used for the connection. The service name is a string that is the global database name—a name that is comprised of the database name and domain name, for example: sales.us.acme.com.
SID
The Oracle System Identifier that refers to the instance of Oracle running on the server. The default is ORCL.
Note: SID and ServiceName are mutually exclusive. Only one or the other can be specified in the data source; otherwise, an error is generated.