search

snowch / biginsight-examples

Example projects to help you quickly get started with BigInsights
Apache License 2.0
7 stars 4 forks source link

Create ODBC example #45

Open snowch opened 8 years ago

snowch commented 8 years ago

We could possible automate creating the odbc.ini file:

[BIGSQL]
Security=ssl
DATABASE=BIGSQL
HOSTNAME=ehaasp-XXX-master-1.bi.services.bluemix.net
PORT=51000
SSLServerCertificate=C:\cert\server\mydbserver.arm
UID=dsbsdes
PWD=XXXXX

Some tips from a previous installation:

BigSQL in v4.1 has been installed with SSL. In order to connect to it, you need the arm file used in the database (I requested via ticket) . It's on /home/bigsql/sqllib/security/keystore/ but biadmin has not rights to read it.

Question - is this certificate different from the https certificate that we use to connect to BigSQL with Jdbc?

Note that the odbc drivers need to be manually downloaded:

I don't think this will make a good example because there is very little that can be automated. If the linux odbc drivers could be made available publicly, we could make an automated example using the Vagrant environment.

snowch commented 8 years ago

@pregazzoni - any thoughts on this?

pregazzoni commented 8 years ago

Agree, might be too complex to fully automate. Could be done with some pre-req eg.:

  1. get odbc driver and provide local path
  2. get arm file and provide local path
pregazzoni commented 8 years ago

and seems like permission of .arm file might be an issue: -r-------- 1 bigsql hadoop 1911 Apr 19 10:35 mydbserver.arm