forked from mikew-heavyai/heavyai-devstack
-
Notifications
You must be signed in to change notification settings - Fork 2
/
configHeavyConnect.sh
executable file
·62 lines (52 loc) · 1.37 KB
/
configHeavyConnect.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
#!/bin/bash
cat > "/var/lib/heavyai/odbc/odbcinst.ini" <<odbcinstiniEnd
[ODBC Drivers]
Snowflake=Installed
Redshift=Installed
PostgreSQL=Installed
[Snowflake]
APILevel=1
ConnectFunctions=YYY
Description=Snowflake DSII
Driver=/usr/lib/snowflake/odbc/lib/libSnowflake.so
[Redshift]
Description=Redshift ODBC driver
Driver = /opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so
[PostgreSQL]
Description=PostgreSQL ODBC driver
Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
Debug=0
CommLog=1
UsageCount=1
odbcinstiniEnd
cat > "/var/lib/heavyai/odbc/odbc.ini" <<odbciniEnd
[ODBC Data Sources]
Redshift=Redshift
Snowflake = Snowflake
PostgreSQL=PostgreSQL
[Snowflake]
Description=SnowflakeDB
Driver=Snowflake
Locale=en-US
SERVER=lqa26912.snowflakecomputing.com
PORT=443
SSL=on
ACCOUNT=lqa26912
[PostgreSQL]
Description=Local default PostgreSQL database
Driver=PostgreSQL
Database=postgres
Servername=localhost
Port=5432
[Redshift]
# This key is not necessary and is only to give a description of the data source.
Description=Amazon Redshift ODBC Driver (64-bit) DSN
# Driver: The location where the ODBC driver is installed to.
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so
# Required: These values can also be specified in the connection string.
Server=[Server]
Port=[Port]
Database=[Database]
locale=en-US
odbciniEnd