PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.5.9
- All Products
[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.