Connecting and Importing via a Data Warehouse

Find here all information about importing data from a Data Warehouse.

INFO

You can ingest data directly into Spectrum via a Data Warehouse. Creating a connection and executing an import job is not needed separately.

List of Supported Data Warehouses

The following Data Warehouses are supported:

Import only:

Note that a Data Warehouse connection for importing data can be used for incremental processing.

• Amazon Redshift
• MySQL
• JDBC generic

Import/ Export:

Note that a Data Warehouse connection for an export can be used within an Export Sheet.

• Snowflake

Data Warehouse for Amazon Redshift

To proceed data import via Amazon Redshift:

1. Click the "+" button and choose "Data Warehouse" The dialog 'Data Warehouse' opens.

   

2. Select "Redshift" from the drop-down.

   

3. Replace the placeholder within the 'Connection String' for 'endpoint', 'port' as well as for 'database' with your matching string information.

   

4. Enter the authentication information: Enter the username and password from your Amazon Redshift credentials.

   

5. Enter your personal Data Warehouse connection name under "Save as", if needed, add a description, and confirm with Submit. The Data Warehouse connection configuration is finished.

   

Data Warehouse for MySQL

To proceed data import via MySQL:

1. Click the "+" button and choose "Data Warehouse" The dialog 'Data Warehouse' opens.

   

2. Select "MySQL" from the drop-down.

   

3. Replace the placeholder within the 'Connection String' for 'host', 'port' as well as for 'database' with your matching string information.

   

4. Enter the authentication information: Enter the username and password from your MySQL credentials.

   

5. Enter your personal Data Warehouse connection name under "Save as", if needed, add a description, and confirm with Submit. The Data Warehouse connection configuration is finished.

   

Data Warehouse for Snowflake

To proceed data import via Snowflake:

1. Click the "+" button and choose "Data Warehouse" The dialog 'Data Warehouse' opens.

   

2. Select "Snowflake" from the drop-down.

   

3. Enter your Snowflake credentials: "URL", "Username", "Password", "Database". If needed, enter also the "Warehouse" name.

   

4. Select the 'Usage' from the drop-down: Select "Import", "Export" or "Import and Export".

   

5. If you also want to export, select the "Storage Type" from the drop-down.

   

6. Enter the respective credentials information for the export.

   

   or

   

7. Enter your personal Data Warehouse connection name under "Save as", if needed, add a description, and confirm with Submit. The Data Warehouse connection configuration is finished.

   

Data Warehouse for JDBC Generic Connections

Prerequisites

In order to use Data Warehouse for JDBC generic connections, make sure you prepared the following:

1. Ensure that your Spectrum instance is not currently running.

2. Insert your "JDBC generic connections" driver as well as the "license" file that you received from our service team into the 'etc/custom-jars' folder manually.

3. Start your Spectrum instance.

4. Double-click the JDBC generic connection file. The driver UI opens (GUI needed)

5. Find the connection string in the tab 'Connection' -> 'Connection String' and copy the string.

6. Enter the connection string in the "Data Warehouse" dialog when creating the Data Warehouse connection.

Configuring the Connection

To proceed the data import via a JDBC generic connection:

1. Click the "+" button and choose "Data Warehouse" The dialog 'Data Warehouse' opens.

   

2. Select "JDBC generic connection" from the drop-down.

   

3. Enter the "Connection String" from the JDBC driver prerequisites.

   

4. Enter your personal Data Warehouse connection name under "Save as", if needed, add a description, and confirm with Submit. The Data Warehouse connection configuration is finished.