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]
    MyHDPDataSource=DataDirect HDP 4.6

    [ODBC]
    IANAAppCodePage=4
    InstallDir=ODBCHOME
    Trace=0
    TraceFile=odbctrace.out
    TraceDll=ODBCHOME/lib/ddtrc28.so
	
    [MyHDPDataSource]
    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