Supported data sources

Ways to connect to your data

The way that you connect to your data depends on several factors, including the services that are installed on Cloud Pak for Data. Some services can use connections that are defined at the platform-level, while other services use connections that are specific to the service.

Use the following list to determine which method is appropriate for your use case.

Creating connections at the platform level

In general, platform-level connections simplify the process of creating and maintaining connections. You create the connection and then multiple services can refer to the connection. If you update the connection, the changes are automatically picked up by the analytics projects that use the connection.

You can create platform-level connections from the Platform connections page. These connections can be used by various services across the platform. However, the Platform connections page is available only if the Cloud Pak for Data common core services are installed.

For more information, see Connecting to data sources at the platform level.

Consider creating connections at the platform level if the following statements are true:

• The services support platform-level connections.
• The same connection needs to be used by multiple services or instances or across multiple projects.
• You have the appropriate permissions to create platform-level connections.

  You must have the Editor or Admin role on the Platform connections page. For more information, see Managing collaborators on platform connections.

Platform connections are visible to all platform users. However, only users with the credentials for the data source can use the connection.

If you don't see the type of data source that you want to connect to, a Cloud Pak for Data administrator can upload the JDBC driver JAR files so that you can create a generic JDBC connection to the data source. For more information, see Importing JDBC drivers for data sources.

Not all services support the same types of connections. If you want to use a connection from the Platform connections catalog, the list of connections is filtered based on the types of connections that the service supports. For example, if you are using a connection to add a data source to an analytics project, only connections that are supported for analytics projects are displayed.

Creating connections at the service level

Create connections at the service level, if any of the following statements are true:

• The service that you are using does not support platform-level connections.
• You don't have the appropriate permissions to create platform-level connections.
• You don't want the connection to be included in the Connections catalog for security reasons.

For more information, see Connecting to data sources at the service level.

Connection types

The following table lists the data sources that you can connect to from Cloud Pak for Data.

Other data sources

An administrator can upload JDBC drivers to enable connections to more data sources. See Importing JBDC drivers for data sources.

The Data Virtualization service supports connections that are established by using third-party JDBC drivers.

See the product roadmap at http://ibm.biz/AnalyticsRoadmaps for information about support for more data sources.

Data files

In addition to using data from remote data sources or integrated databases, you can use data from files. You can work with data from the following types of files.

Connecting to data sources (by service)

Use the following resources to create connections in your application.

Cognos Dashboards

You can use the local and remote data sets that exist in your analytics projects.

Alternatively, you can create connections that can be used in an analytics dashboard by selecting Add data source from the analytics dashboard menu.

Restriction: Analytics dashboards support only JDBC-based connections.

You can also add data from files by selecting Add data set from the analytics dashboard menu.

Data Refinery

You can cleanse and refine tabular data with a graphical flow editor tool called Data Refinery. To refine data, you must add connections to your data sources and you must understand source file limitations. For more information, see Refining data (Data Refinery) and Supported data sources for Data Refinery.

DataStage

DataStage uses connectors on the DataStage canvas to interact with remote data sources. To connect to the data source, you need to create a project connection asset for the associated DataStage connector before you can use it in DataStage.

• For instructions on creating a project connection asset, see Adding connections to analytics projects.
• For the list of available DataStage connectors, see DataStage connectors.
• To add a local file such as a CSV file, see Adding data to an analytics project.

Data Virtualization

You can create connections that can be used to virtualize data from the following locations:

• The Platform connections page
• The Data sources page in the Data Virtualization service.

For more information, see Adding data sources (Data Virtualization).

SPSS Modeler

Data sources in the SPSS Modeler service support read-only access, read/write access, and SQL pushback.

The SPSS Modeler service also supports several other file types.

For more information, see Supported data sources for SPSS Modeler.

Watson Knowledge Catalog

You can create connections that can be used in the catalog and connections that can be used to curate data.

For connections that can be used in a catalog, you can create connections from the catalog Overview page.

For more information, see Adding a connection asset to a catalog (Watson Knowledge Catalog).

For connections that can be used to curate data, you can create connections from the following locations:

• The Platform connections page
• The Governance > Data discovery page when you create a new discovery job

For more information, see the following resources.

• Running automated discovery
• Running a quick scan

Watson Studio

Ideally, use data that is already in a catalog. Search for the data you want in a catalog and add it to an analytics project.

Alternatively, you can create connections that can be used in analytics projects from the following locations:

• The Connections page
• The Assets page of the analytics project

You can also add data from files. To add data from files, go to the Assets page of the analytics project.

For more information, see Adding data to an analytics project.

Learn more

• Planning to access data
• Asset previews
• Profiles of assets