Configure Data Sources

From DMXDeepInsight
Jump to: navigation, search

Connect to database data sources

Supported databases

These databases are supported.

  • Amazon RedShift
  • Apache Cassandra
  • Apache Spark
  • DB2 LUW
  • Informix
  • Maria
  • Microsoft SQL Server
  • MS Excel
  • MySQL
  • Oracle
  • PostgreSQL
  • SAP HANA
  • Sybase Anywhere
  • Sybase ASE
  • Sybase IQ
  • Teradata Aster

Before you begin

  • Ensure the data conforms with the Data Source Limits.
  • Ensure you have this information:
    • Name of the server that hosts the database you want to connect to and port number
    • Database name
    • Username and password
  • Check whether you have database drivers installed on your computer. DeepInsight needs a JDBC driver to connect to a database. If the driver is not already installed on your computer, then you can download it from the vendor’s website.

Connect to a database

Follow the instructions below to connect to a database.

  1. Open the configure data sources page and click the plus sign in the My Data Sources pane.
  2. In the Database tab, select your database from the Database Type drop-down.
  3. Provide the data source name and description.
  4. Type the IP address of the host where the database instance is running and the type the port number that the database uses.
  5. Type the username of the database for accessing the database instance and the corresponding password for the username provided.
  6. Click Test Connection.
  7. After successful verification, click Save. DeepInsight saves the database information and displays the database in the My Data Sources pane.

Troubleshooting tips

  • Check if the database is running.
  • Check if the server name or the port number is misspelled or incorrect.
  • Check if a firewall is blocking the entered port number.
  • Contact your system administrator if none of the issues mentioned above resolves connection issue.

Connect to file data sources

Supported flat files

These flat files are supported:

  • Delimited text files (comma (,) separated, tab separated, semi-colon (;) separated, space separated, pipe (|) separated)
  • Excel Files (.xls and .xlsx)
  • Web Files
  • Amazon S3
  • Google Drive

Before you begin

Ensure that any file you import conforms to the Data Source Limits.

Import CSV & Excel files

Follow the instructions below to upload a file from your desktop.

  1. Open the configure data sources page and click the plus sign in the My Data Sources pane.
  2. Provide the data source name and description.
  3. Select a character encoding type and a number format locale.
  4. In the Browse File area, under the My Computer tab, browse and upload your file data source in DeepInsight.
  5. (Applicable only to Excel Files) In the Excel Sheets dialog, expand Excel Sheets, choose your worksheet, and then click Add to DMXDeepInsight.

DeepInsight imports the file data into a data grid where it automatically identifies the format for the imported data and categorises it into different datatypes. You can select a different datatype for each column and can also set your date format.

If the user-selected datatype does not conform with DeepInsight datatypes norm, then a null value is inserted in place of the user-defined datatype

Follow the instructions below to verify datatype.

  1. Click Verify Datatype.
  2. In the Verify Datatype dialog, verify and make corrections to the string attributes and then click Apply. You can also click the drop-down arrow on each column in the grid, without opening the dialog.
  3. After you have verified, click Save. DeepInsight will implicitly create a dataset for the connected flat file.
  4. In the Add Dataset dialog, provide a name for your dataset and then click Add. DeepInsight creates a dataset for the flat file in the Dataset page. It saves the flat file connection details in the My Data Sources area and dataset details in the My Data area.

Import data from Google Drive

Follow the instructions below to upload a file from Google Drive.

  1. Open the configure data sources page and click plus sign in the My Data Sources pane.
  2. Provide the data source name and description.
  3. Select a character encoding type and a number format locale.
  4. In the Browse File area, under the Google Drive tab, click Connect.
  5. Sign into your Google Drive account and give access permissions to DeepInsight.
  6. In the Google Drive dialog, expand Google Drive, and choose your file and then click Add to DMXDeepInsight. In the Excel Sheets dialog, expand Excel Sheets, choose your sheet, and then click Add to DMXDeepInsight.

DeepInsight imports the file data into a data grid where it automatically identifies the format for the imported data and categorizes it into different datatypes. You can select a different datatype for each column and can also set your date format.

If the user-selected datatype does not conform with DeepInsight datatypes norm, then a null value is inserted in place of the user-defined datatype.

Follow the instructions below to verify datatype.

  1. Click Verify Datatype.
  2. In the Verify Datatype dialog, verify and make corrections to the string attributes and then click Apply. You can also click the drop-down arrow on each column in the grid, without opening the dialog.
  3. After you have verified, click Save. DeepInsight will implicitly create a dataset for the connected flat file. In the Add Dataset dialog, provide a name for your dataset and then click Add. DeepInsight creates a dataset for the flat file in the Dataset page. It saves the flat file connection details in the My Data Sources area and dataset details in the My Data area.

Import data from the Web

Follow the instructions below to upload a file from the Web.

  1. Open the configure data sources page and click plus sign in the My Data Sources pane.
  2. Provide the data source name and description.
  3. Select a character encoding type and a number format locale.
  4. In theBrowse File area, under The Web tab, enter the URL of the location from where you want to import the file, and then click Add to DMXDeepInsight.
  5. In the Excel Sheets dialog, expand Excel Sheets, choose your sheet, and then click Add to DMXDeepInsight.

DeepInsight imports the file data into a data grid where it automatically identifies the format for the imported data and categorizes it into different datatypes. You can select a different datatype for each column and can also set your date format.

If the user-selected datatype does not conform with DeepInsight datatypes norm, then a null value is inserted in place of the user-defined datatype.

Follow the instructions below to verify datatype.

  1. Click Verify Datatype.
  2. In the Verify Datatype dialog, verify and make corrections to the string attributes and then click Apply. You can also click the drop-down arrow on each column in the grid, without opening the dialog.
  3. After you have verified, click Save. DeepInsight will implicitly create a dataset for the connected flat file.
  4. In the Add Dataset dialog, provide a name for your dataset and then click Add. DeepInsight creates a dataset for the flat file in the Dataset page. It saves the flat file connection details in the My Data Sources area and dataset details in the My Data area.

Import data from Amazon S3

Follow the instructions below to upload a file Amazon S3.

  1. Open the configure data sources page and click plus sign in the My Data Sources pane.
  2. Provide the data source name and description.
  3. Select a character encoding type and a number format locale.
  4. In the Browse File area, under Amazon S3 tab, enter access key and secret key, and then click Connect.
  5. In the S3 Buckets dialog, expand Amazon Data Source, choose your file, and then click Add to DMXDeepInsight. In the Excel Sheets dialog, expand Excel Sheets, choose your sheet, and then click Add to DMXDeepInsight.

DeepInsight imports the file data into a data grid where it automatically identifies the format for the imported data and categorizes it into different datatypes. You can select a different datatype for each column and can also set your date format.

If the user-selected datatype does not conform with DeepInsight datatypes norm, then a null value is inserted in place of the user-defined datatype.

Follow the instructions below to verify datatype.

  1. Click Verify Datatype.
  2. In the Verify Datatype dialog, verify and make corrections to the string attributes and then click Apply. You can also click the drop-down arrow on each column in the grid, without opening the dialog.
  3. After you have verified, click Save. DeepInsight will implicitly create a dataset for the connected flat file.
  4. In the Add Dataset dialog, provide a name for your dataset and then click Add. Deep Insight creates a dataset for the flat file in the Dataset page. It saves the flat file connection details in the My Data Sources area and dataset details in the My Data area.

Connect to web connector data sources

Data sources for a web data connector can include Facebook feeds and JSON data that are available over HTTP or HTTPS. A web data connector is an HTML file that includes JavaScript code and is hosted on a web server running on your computer or a web server.

Before you begin

Ensure that any file you import conforms the Data Source Limits.

Import data

Follow the instructions below to import data via web data connectors.

  1. Open the configure data sources page and click plus sign in the My Data Sources pane.
  2. In the Web Data Connectors tab, provide the data source name and description.
  3. In the Enter Web Connector URL field, provide the URL of your web connector and then click Connect.
  4. In the Web Data Connector page, you can either provide the URL for the file or drag-and-drop the file in the text box, or paste the code in the text box.
  5. After you are done, click Save, and then click Add to DMXDeepInsight. DeepInsight saves the web data connector details in the My Data Sources area and dataset details in the My Data area.