Tips and tricks on using a DB2 LUW data source with Data Science Experience (DSX)
ryanmark 120000EPU7 Visits (8124)
Data Science Experience is an extremely powerful and flexible platform for exploring a wide variety of tools and capabilities related to data science. For example, DSX brings together all the assets you need (including working code, sample data sets, and in-depth tutorials) to explore the power of machine learning.
A rich set of information is available to help you create connections in scenario #3, including:
However, even with these resources, it can be a bit tricky to navigate the objects that you need to create and the credentials that need to be used to exploit on-premises data sources (like a DB2 database) with DSX Public Cloud. This blog augments the information linked to above with some additional details that you need to know about to take advantage of scenario #3: using DSX Public Cloud with a private cloud / local data source.
To start with, let's look at the objects that you need to create for scenario #1 - all public cloud. In this simple scenario (e.g. dashDB as a data source for DSX Public Cloud), the only DSX object that you need to define in addition to the Notebook containing the connection code is a Connection object for the data source:
Both these objects use the same set of credentials: the host, port, database, ID and password that you get from the Service Credentials section in Bluemix for your dashDB service. The following screen shot shows these credentials highlighted in red:
Now consider using a DB2 LUW data source in DSX Public Cloud. In this scenario, there are a total of four objects that you need to define. In addition to the DSX Notebook and Connection that you needed in the all public cloud scenario, you also need to create a Secure Gateway object in Bluemix as well as a client on the system where you private cloud / local data source resides:
In the information resources linked to at the beginning of this blog, there are a few key points that aren't entirely clear. Following is a list of the key points that you need to remember when you're setting up a private cloud / local data source for DSX Public Cloud: