skip to main content
Configuring Hybrid Data Pipeline Driver for ODBC : Configuring an ODBC data source on UNIX and Linux systems : Configuring a data source in the system information file : Sample odbc.ini file
  

Try Now
Sample odbc.ini file
You can use the odbc.ini file installed with the driver as a template for the system information file. The following sample shows how this file can be modified. All occurrences of ODBCHOME should be replaced with your installation directory path during installation of the file. Values that you must supply are enclosed by angle brackets (< >). If you are using the installed odbc.ini file, you must supply the values and remove the angle brackets.
Note: The prefix for the 32-bit driver file name is iv. The prefix for the 64-bit driver file name is dd.

[ODBC Data Sources]
DataDirect HDP=<odbc_data_source_name>

[ODBC]
IANAAppCodePage=4
InstallDir=ODBCHOME
Trace=0
TraceFile=odbctrace.out
TraceDll=ODBCHOME/lib/ddtrc27.so

[DataDirect HDP]
Driver=ODBCHOME/lib/ddhybrid01.so
Description=
Service=<hdp_dns_name>
HybridDataPipelineDataSource=<hdp_data_source>
LogonID=<hdp_user_name>
ClientTimeZone=
DataSourceUser=<datastore_user_name>
DataSourcePassword=<datastore_user_password>
ProxyHost=
ProxyPort=
ProxyUser=
ProxyPassword=
TransactionMode=0
WSRetryCount=3
WSTimeout=120
LogonDomain=
LoginTimeout=30
QueryTimeout=0
ApplicationUsingThreads=1
ReportCodepageConversionErrors=0
EnableWCharSupport=1
DefaultlongDataBufLen=
MaxVarcharSize=
ExtendedOptions=
VarcharThreshold=
MinLongVarcharSize=
Password=<hdp_user_password>
EncryptionMethod=0
ValidateServerCertificate=1
TrustStore=
TrustStorePassword=
HostNameInCertificate=
PortNumber=80