Skip to main content

Change Data Source Provider

Use the Change Connection Provider feature to switch a data source connection to a different provider — for example, when a provider is outdated, has stopped working, or a better alternative has become available.

For safety, the feature does not modify the existing data source connection. Instead, it creates a copy of the connection configured for the new provider, leaving the original connection unchanged.

Note:

Changing from a CData REST provider to the Jet Analytics REST provider is not supported. This is due to fundamental differences in how the two providers work — CData uses RSD files for configuration, whereas the Jet Analytics REST provider uses an endpoint setup with XSLT code. If your API uses OData, the OData metadata discovery URL can be used for automatic endpoint discovery. If it uses OpenAPI or Swagger, the specification can be imported to configure endpoints more quickly.

Change the provider for a data source connection

  1. In the Jet Analytics Portal, navigate to the Data source connections page, or open the details page for the connection you want to change.

    The Jet Analytics portal is managed by the insightsoftware Support team. For assistance or additional information, reach out to Product Support .

  2. Click the ⋮ context menu on the data source connection and select Change connection provider.
  3. On the Change provider page, select the new provider. The form updates to match the selected provider's fields, pre-filled with values from the existing connection. The name of the new connection will have COPY appended to distinguish it from the original.
  4. If some fields from the old provider cannot be mapped to the new provider, an Unmapped fields section appears. Review each unmapped field and take the appropriate action:
    • If the providers use different names for the same setting (for example, "host" vs "server"), copy the value to the corresponding field in the new form.
    • If a field has no equivalent in the new provider, it can be left blank or ignored.
  5. Click Save.
  6. In Jet Analytics Data Integration, update each data source that should use the new connection. Open the Ingest instance, right-click the data source, and select Edit… Under Connection, click Change and select the new data source connection.

Was this article helpful?

We're sorry to hear that.