Create:
1 Register a IBM ID and log in IBM Bluemix. Https://console.ng.bluemix.net
2 Go to "DASHBOARD" and create a space.
3 Find ADD A SERVICE OR API and click. Choose DashDB and CREATE database.
Connect:
1 Launch The DashDB database and you can load data and so on.
2 Choose Connect, connect Setting. There is some parameters needed.
3 Download driver package first and install, and refer the link to install:
Http://www-01.ibm.com/support/knowledgecenter/SS6NHC/com.ibm.swg.im.dashdb.doc/connecting/connect_driver_package.html
From a command prompt, enter the following commands. These commands create new entries in the Driver configuration file (DB2DSDRIVER.CFG) on your computer and set the Connecti On attributes. You need to does this step only one time.
Note:the "Db2cli" is located in folder "Bin"
For a connection without SSL:
DB2CLI writecfg add-database bludb-host hostname-port 50000
DB2CLI writecfg add-dsn alias-database bludb-host hostname-port 50000
For a connection with SSL:
DB2CLI writecfg add-database bludb-host hostname-port 50001
DB2CLI writecfg add-dsn alias-database bludb-host hostname-port 50001
DB2CLI writecfg add-database bludb-host hostname-port 50001-parameter "Securitytransportmode=ssl"
where
Hostname
The host name of the DashDB database obtained from the Connect > Connection Settings page.
Alias
The name for a alias that is want to establish the connection. Choose a name that's meaningful to you; For example, analytics.
Optional:to test the connection to the DashDB database, run this command from the command prompt:
DB2CLI validate-dsn alias-connect-user userid-passwd Password
where
Alias
The name of the alias that is created with the DB2CLI writecfg command in step 1
Userid
Your DashDB user ID.
Password
The password that's use to connect to DashDB.
Please refer:http://www-01.ibm.com/support/knowledgecenter/ss6nhc/com.ibm.swg.im.dashdb.doc/connecting/connect_ Connecting_cli_and_odbc_applications.html
The file db2dsdriver.cfg is located in C:\ProgramData\IBM\DB2\IBMDBCL1\cfg in Windows,./dsdriver/cfg in Linux.
in Windows:
with the ODBC Data Source Administrator window to add an ODBC data source Name (DSN) for the DashDB database:
on the User DSN tab, click Add.
on the Create New Data Source window, select the driver-is named IBM DB2 O DBC DRIVER and click Finish.
in the ODBC IBM driver-add window, enter a data source name (usually the name of the database is connecting to) , and click Add.
from the Cli/odbc Settings window, on the Data Source tab, enter the user ID and password by using the ODBC DSN settin GS for your database that is provided in the Connect your applications to the database page.
on the Advanced Settings page, for each of the following parameters, click Add to open the add CLI Parameter window to begin the step, and click OK to return to the Settings page:
Select the Database parameter, then click OK to open the Cli/odbc Settings window. In the Pending Value field, enter the database name Value, which noted from the Set up > Connect Applications page. Select The Hostname parameter, then click OK to open the Cli/odbc Settings window. In the Pending value field, enter the host name value, which is noted from the Set up > Connect Applications page.
Select The Port parameter, then click OK to open the Cli/odbc Settings window. In the Pending value field, enter the port number Value, which is noted from the Set up > Connect Applications page.
Select The Protocol parameter, then click OK to open the Cli/odbc Settings window. Select TCP/IP.
Click OK to return to the ODBC Data Source Administrator window.
On the User DSN tab, select the data source name and then click Configure.
On the Cli/odbc Settings window, click Connect to test the connection.
If the connection is successful, click OK to return to the ODBC Data Source Administrator window, and then click OK to Exi t the window.
If the connection is not a successful, note and correct any errors before you test the connection again.
Refer:http://www-01.ibm.com/support/knowledgecenter/ss6nhc/com.ibm.swg.im.dashdb.doc/connecting/connect_ Connecting_spss_statistics.html
In Linux
After the steps above, enter <modeler Server>/bin directory, run below command to create symbol link for Libspssodb C_db2cli.so:
# rm-f Libspssodbc.so
# ln-s libspssodbc_db2cli.so libspssodbc.so
Then edit the modelersrv.sh and add Db2profile file:
. /<dashdb Driver>/db2profile
Note:there is a space between. and/
Now you can start Modeler Server and test it.
IBM SPSS Modeler Configuration uses the DashDB database