Add and Map a Data Source Connection in the Jet Analytics Portal

Note: Released in Jet Analytics 6024.1.

Ingesting data from a data source to an Ingest instance begins in the Jet Analytics Portal.

The Jet Analytics Portal is managed by insightsoftware. Please contact Product Support for more information.

Here, you add the data source connection and map it to an Ingest instance. When you open the instance in Jet Analytics Data Integration, you can then use the mapped data source connections when adding a data source.

Adding a data source connection

To add a data source connection, follow the steps below.

1. Go to Data Estate > Data source connections and click Add data source connection.
2. In the Data Source Connection list, select the Type, Provider, and Version you want to use.

   

3. In the Name box, type a name for the data source connection.
4. In the Description box, type a description of the data source connection.
5. Under Connection settings, enter the connection information required by the selected data source.
6. Map the data source to an Ingest instance by selecting an instance and providing the data source name and short name to be used in Jet Analytics Data Integration.

   

Note: All connection credentials are protected with 256-bit AES encryption.

Mapping a data source connection to an Ingest instance

You can map a data source connection to an Ingest instance when creating a new data source connection, as shown above. It is also possible to map the data source connection separately by following the steps below.

1. Go to Data Estate > Instances and click on an Ingest instance.
2. In the Mapped data source connections list, click Add.

   

3. Select the data source connections you want to add from the Data source connection list, provide a name and short name for the data source that will be created in Jet Analytics Data Integration, and then click Add.

   

Adding data sources in Jet Analytics Data Integration

Once you have mapped the data source connection to an Ingest instance, a data source will automatically be created in Jet Analytics Data Integration. To add further data sources in Jet Analytics Data Integration using existing data source connections, see How to add a Private Data Source.

Other data source connection actions

Cloning a data source connection

If you need to add a new data source connection that is mostly the same as an existing one, you can clone the existing connection instead of starting from scratch. On the Data Source Connections page, in the Actions column, click the Clone button.

This will open a page similar to the Add Data Source page, prefilled with data from the cloned data source. Click Save to save the cloned data source connection.

Remove a data source connection

Follow the steps below to delete a data source mapping.

1. In the Mapped data source connections list, click Delete in the Actions column for the data source you want to remove.

   

2. In the Remove data source connection modal, confirm that you want to remove the mapping by clicking Remove.