PowerExchange for Cassandra User Guide

PowerExchange for Cassandra User Guide

Configuring the Informatica Cassandra ODBC Driver on Linux

Configuring the Informatica Cassandra ODBC Driver on Linux

You must configure the Informatica Cassandra ODBC driver with details of the Cassandra database and ODBC driver manager before you can run Cassandra
mappings
.
Edit the
odbc.ini
file to configure the driver in the following location:
<Informatica installation directory>/tools/cassandra/lib/
  1. Enter the correct ODBCInstLib for the ODBC Driver Manager in all the .ini files.
  2. Replace <INFA_HOME> with the path to the Informatica services installation directory in all the .ini files.
  3. Add the following information to the LD_LIBRARY_PATH environment variable:
    • <INFA_HOME>/tools/cassandra/lib
    • 64-bit
      library directory of the ODBC Driver Manager
  4. Add the path of the odbc.ini file to the ODBCINI environment variable.
  5. Add
    AuthMech=1
    in the
    odbc.ini
    file, if you want to connect to a Cassandra database using
    User Name
    and
    Password
    .
    When the authentication mechanism is enable, you must specify the username and password in
    odbc.ini
    file using the following keywords:
    UID=<USER_NAME>
    PWD=<PASSWORD>
  6. Add
    EnableAsynchronousWrites=1
    in the
    odbc.ini
    file, if you want to enable asynchronous write.
  7. Add entries for all the Cassandra data sources in the
    odbc.ini
    file.
    The following section shows a sample entry in the
    odbc.ini
    file:
    [Sample Informatica Cassandra DSN] Description=Simba Cassandra ODBC Driver (64-bit) DSN Driver=<Informatica installation directory>/tools/cassandra/lib/libcassandraodbc-sb64.so Required: You can also specify these values in the connection string. Host=[Host] Port=9042 DefaultKeyspace=[keyspace] uid=[user id] #Advanced Options: You can also specify these values in the connection string. QueryMode=2 TunableConsistency=1 LoadBalancingPolicy=0 BinaryColumnLength=4000 StringColumnLength=4000 #Virtual Table Name Separator VTTableNameSeparator=_vt_ BlacklistFilteringHosts=[Blacklist Filtering Hosts] WhitelistFilteringHosts=[Whitelist Filtering Hosts] BlacklistDatacenterFilteringHosts=[Blacklist Datacenter Filtering Hosts] WhitelistDatacenterFilteringHosts=[Whitelist Datacenter Filtering Hosts] #Asynchronous Writes settings EnableAsynchronousWrites=1 NumConcurrentRequests=100 NumInsertQueryThreads=2 NumIterationsPerInsertThread=50 EnableTokenAware=1 EnableLatencyAware=[Enable Latency Aware] EnableNullInsert=1 EnableCaseSensitive=[Enable Case Sensitive] UseSqlWVarchar=[Use Sql WVarchar] #Paging Settings EnablePaging=1 RowsPerPage=10000 #Check the hostname in the server certificate with the server hostname UseSslIdentityCheck=0 #The full path of the PEM file containing the certificate for verifying the server. SSLTrustedCertsPath=${driver_dir}/${libdir64}/cacerts.pem #The full path of the PEM file containing the certificate for verifying the client. SSLUserCertsPath=[SSL User Certificate Path] #The full path of the file containing the private key used to verify the client. SSLUserKeyPath=[SSL User Key Path] #The password of the private key file. SSLUserKeyPWD=[SSL User Key Password] #Note: You must specify PWD in the connection string if authentication is on. #UID can be saved as a part of the DSN or specified in the connection string.

0 COMMENTS

We’d like to hear from you!