skip to main content
Getting Started : Configuring an ODBC Data Source on UNIX and Linux Systems : Configuring a Data Source in the System Information File
 

Try DataDirect Cloud Now

Configuring a Data Source in the System Information File

DataDirect Cloud Driver for ODBC does not have an ODBC Administrator utility for the UNIX and Linux environments. To configure a data source in the UNIX and Linux environments, you must edit the system information file (by default, odbc.ini) to which the ODBCINI variable points.
You can use the default odbc.ini installed by the installation directory as a template into which you enter your site-specific database connection information. Using a text editor, modify the default attributes in this file as necessary, based on your system values (for example, your server name and port number).
To use DataDirect Cloud, you need to configure a DataDirect Cloud Driver for ODBC data source that connects to a DataDirect Cloud Data Source you created using your DataDirect Cloud account on https://www.progress.com/datadirect-cloud. The following table shows how the entries in the data source map to a cloud account Data Source.
Table 2. ODBC Parameters Required to Connect to a Cloud Data Source
ODBC data source parameters
Values
DDCloudDataSource
The name of the DataDirect Cloud Data Source that this data source will use to connect to the cloud data store.
DataSourceName
Define a unique name for this ODBC data source.
LoginID
The user name for your DataDirect Cloud account.
Password
The password for your DataDirect Cloud account.
DataSourcePassword
If the data store credentials (those for Salesforce, Oracle Service Cloud, etc.) are not stored in the Data Source, provide data store password.
DataSourceUser
If the data store credentials are not stored in the Data Source, provide data store user name.
The following sample shows a MyODBCDSN data source entry that will connect to a DataDirect Cloud Data Source named MyCloudDS, assuming a username for the DataDirect Cloud account of me@mycompany.com, a password of myPassword, and that the data store credentials are stored in the MyCloudDSData Source, therefore DataSourcePassword and DataSourceUser are left empty. The parameter values added to configure this entry are shown in italic font.
[ODBC Data Sources]
Cloud Wire Protocol=DataDirect Cloud Wire Protocol

[Cloud Wire Protocol]
Driver=ODBCHOME/lib/ivd2c01.so
Description=DataDirect Cloud Wire Protocol
ApplicationUsingThreads=1
Database=
DataSourceName=MyODBCDSN
DataSourcePassword=
DataSourceUser=
DDCloudDataSource=MyCloudDS
DefaultlongDataBufLen=
EnableWCharSupport=1
LoginTimeout=30
LogonDomain=
LogonID=me@mycompany.com
MaxVarcharSize=
MinLongVarcharSize=
Password=myPassword
ProxyHost=
ProxyPassword=
ProxyPort=
ProxyUser=
QueryTimeout=0
ReportCodepageConversionErrors=0
Service=
TransactionMode=0
VarcharThreshold=
WSRetryCount=3
WSTimeout=120

[ODBC]
IANAAppCodePage=4
InstallDir=ODBCHOME
Trace=0
TraceDll=ODBCHOME/lib/odbctrac.soTraceFile=odbctrace.out
UseCursorLib=0
See Connecting Applications to the Connectivity Service for information on how to configure your application to use this data source.
* Testing with the demoodbc Application