DSP-6133

.odbc.ini

## If you did not install in the default directory, replace '/opt/datastax/cassandraodbc'
## with the correct location.

[ODBC]
Trace=no

[ODBC Data Sources]
cassandra64=DataStax Cassandra ODBC Driver 64-bit
spark64=Simba Spark ODBC Driver 64-bit
spark64old=Simba Spark ODBC Driver 64-bit
shark64=Simba Shark ODBC Driver 64-bit

[cassandra64]
# This key is not necessary and is only to give a description of the data source.
Description=DataStax Cassandra ODBC Driver 1.0.0

# Driver: The location where the ODBC driver is installed to.
Driver=/opt/datastax/cassandraodbc/lib/64/libdatastaxcqlodbc64.so

# Required: These values can also be specified in the connection string.
Host=10.20.0.4
Port=9042
DefaultKeyspace=[keyspace]
uid=[user id]

# Optional: These values can also be specified in the connection string.
BinaryColumnLength=4000
StringColumnLength=4000
QueryMode=2
UseSqlWVarchar=0
#Paging Settings
EnablePaging=1
RowsPerPage=10000
#The default consistency level is ONE
TunableConsistency=1
#Virtual Table Name Separator
VTTableNameSeparator=_vt_

#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.

[spark64]

# Description: DSN Description.
# This key is not necessary and is only to give a description of the data source.
Description=Simba Spark ODBC Driver (64-bit) DSN

# Driver: The location where the ODBC driver is installed to.
Driver=/opt/simba/sparkodbc/lib/64/libsimbasparkodbc64.so

# The DriverUnicodeEncoding setting is only used for SimbaDM
# When set to 1, SimbaDM runs in UTF-16 mode.
# When set to 2, SimbaDM runs in UTF-8 mode.
#DriverUnicodeEncoding=2

# Values for HOST, PORT, KrbHostFQDN, and KrbServiceName should be set here.
# They can also be specified on the connection string.
HOST=10.20.0.4
PORT=11011
Schema=default
FastSQLPrepare=0
UseNativeQuery=0

# The Spark Server Type
# 1 - Shark Server 1 for Shark 0.8.1 and earlier
# 2 - Shark Server 2 for Shark 0.9.*
# 3 - Spark Thrift Server for Shark 1.1 and later
SparkServerType=3

# The Authentication Mechanism for Shark Server 2 and Spark Thrift Server
# 0 - No authentication.
# 1 - Kerberos authentication
# 2 - Username authentication.
# 3 - Username/password authentication.
AuthMech=3

KrbHostFQDN=[Spark Server 2 Host FQDN]
KrbServiceName=[Spark Server 2 Kerberos service name]
UID=datastax
PWD=datastax

[shark64]

# Description: DSN Description.
# This key is not necessary and is only to give a description of the data source.
Description=Simba Shark ODBC Driver (64-bit) DSN

# Driver: The location where the ODBC driver is installed to.
Driver=/opt/simba/sharkodbc/lib/64/libsimbasharkodbc64.so

# The DriverUnicodeEncoding setting is only used for SimbaDM
# When set to 1, SimbaDM runs in UTF-16 mode.
# When set to 2, SimbaDM runs in UTF-8 mode.
#DriverUnicodeEncoding=2

# Values for HOST, PORT, KrbHostFQDN, and KrbServiceName should be set here.
# They can also be specified on the connection string.
HOST=10.20.0.4
PORT=11000
Schema=default
FastSQLPrepare=0
UseNativeQuery=0
SharkServerType=1
AuthMech=0
KrbHostFQDN=[Shark Server 2 Host FQDN]
KrbServiceName=[Shark Server 2 Kerberos service name]
UID=datastax
PWD=datastax


[spark64old]

# Description: DSN Description.
# This key is not necessary and is only to give a description of the data source.
Description=Simba Spark ODBC Driver (64-bit) DSN

# Driver: The location where the ODBC driver is installed to.
Driver=/opt/simba/sparkodbc/lib/64/libsimbasparkodbc64.so

# The DriverUnicodeEncoding setting is only used for SimbaDM
# When set to 1, SimbaDM runs in UTF-16 mode.
# When set to 2, SimbaDM runs in UTF-8 mode.
#DriverUnicodeEncoding=2

# Values for HOST, PORT, KrbHostFQDN, and KrbServiceName should be set here.
# They can also be specified on the connection string.
HOST=10.20.0.4
PORT=10000
Schema=default
FastSQLPrepare=0
UseNativeQuery=0

# The Spark Server Type
# 1 - Shark Server 1 for Shark 0.8.1 and earlier
# 2 - Shark Server 2 for Shark 0.9.*
# 3 - Spark Thrift Server for Shark 1.1 and later
SparkServerType=1

# The Authentication Mechanism for Shark Server 2 and Spark Thrift Server
# 0 - No authentication.
# 1 - Kerberos authentication
# 2 - Username authentication.
# 3 - Username/password authentication.
AuthMech=2

KrbHostFQDN=[Spark Server 2 Host FQDN]
KrbServiceName=[Spark Server 2 Kerberos service name]
UID=datastax
PWD=datastax

.odbcinst.ini

## If you did not install in the default directory, replace '/opt/datastax/cassandraodbc'
## with the correct location.

[ODBC Drivers]
DataStax Cassandra ODBC Driver 64-bit=Installed
Simba Spark ODBC Driver 64-bit=Installed
Simba Shark ODBC Driver 64-bit=Installed

[DataStax Cassandra ODBC Driver 64-bit]
Description=DataStax Cassandra ODBC Driver(64-bit)
Driver=/opt/datastax/cassandraodbc/lib/64/libdatastaxcqlodbc64.so

[Simba Spark ODBC Driver 64-bit]
Description=Simba Spark ODBC Driver (64-bit)
Driver=/opt/simba/sparkodbc/lib/64/libsimbasparkodbc64.so

[Simba Shark ODBC Driver 64-bit]
Description=Simba Shark ODBC Driver (64-bit)
Driver=/opt/simba/sharkodbc/lib/64/libsimbasharkodbc64.so

simba.sharkodbc.ini

# To use this INI file, replace [INSTALLDIR] with the
# directory the tarball was extracted to.

[Driver]

## - Note that this default DriverManagerEncoding of UTF-32 is for iODBC.
## - unixODBC uses UTF-16 by default.
## - If unixODBC was compiled with -DSQL_WCHART_CONVERT, then UTF-32 is the correct value.
##   Execute 'odbc_config --cflags' to determine if you need UTF-32 or UTF-16 on unixODBC
## - SimbaDM can be used with UTF-8 or UTF-16.
##   The DriverUnicodeEncoding setting will cause SimbaDM to run in UTF-8 when set to 2 or UTF-16 when set to 1.

DriverManagerEncoding=UTF-32
ErrorMessagesPath=[INSTALLDIR]/simba/sharkodbc/ErrorMessages/
LogLevel=0
LogPath=


## - Uncomment the ODBCInstLib corresponding to the Driver Manager being used.
## - Note that the path to your ODBC Driver Manager must be specified in LD_LIBRARY_PATH (LIBPATH for AIX).
## - Note that AIX has a different format for specifying its shared libraries.

# Generic ODBCInstLib
#   iODBC
ODBCInstLib=libiodbcinst.so

#   SimbaDM / unixODBC
#ODBCInstLib=libodbcinst.so

# AIX specific ODBCInstLib
#   iODBC
#ODBCInstLib=libiodbcinst.a(libiodbcinst.so.2)

#   SimbaDM
#ODBCInstLib=libodbcinst.a(odbcinst.so)

#   unixODBC
#ODBCInstLib=libodbcinst.a(libodbcinst.so.1)