When using Watson Analytics, I would like to import data using a data connection rather than using a raw file upload such as an .XLS, .XLSX, .CSV, .SAV.
Unfortunately, when I attempt to import data by tapping ‘New Data’ > ‘Connection’ from the Welcome page, no connections are listed. How do I connect to an external database?
Watson Analytics offers many data connectors to be used to import various forms of data. The list of available data connectors is ever-increasing as our development team continues to implement new connectors to suit the needs of our customers.
Currently, the list of connectors offered through Watson Analytics are as follows (these can be found in Account Settings > Data Connections):
- Amazon Redshift
- Apache Hive
- Cloudera Impala
- IBM Cognos BI Server
- IBM dashDB
- IBM DB2, IBM DB2 for I, IBM DB2 for z/OS
- IBM Informix
- IBM PureData for Analytics
- IBM SQL Database
- Microsoft Azure SQL
- Microsoft SQL Server
- MySQL on Compose
- Pivotal Greenplum
- PostgreSQL on Compose
- Sybase IQ
When you tap ‘+ New Data’ from the Watson Analytics Welcome page, then navigate to the Connections tab, you will find that no connections are listed.
This is completely normal, as the data connector hasn’t been set up in Account Settings.
In order to import data through a data connector, the connection will need to first be specified through Data Connection settings by the administrator of the tenant. Once configured, the connection will appear as a source from which users may import data.
To add your data connection, the administrator needs to access the ‘Account Settings’ page found in the top right of the UI – displayed as a user icon.
From the Account Settings screen, choose the ‘Data Connections’ tab. Add a data connection by selecting the ‘+’ icon from the top right hand corner of your screen.
Once the connection has been added, you will find that by tapping: ‘+ New Data’ > ‘Connection’ from the welcome page, the database connection you’ve configured is now available to be used as a data source. Both creators and administrators alike may then use this preconfigured data connection to import data to Watson Analytics.