IBM SPSS Modeler Configuration uses the DashDB database

Source: Internet
Author: User
Tags dsn ibm db2

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.