Import data connections

In Pentaho Data Catalog, you can import and configure multiple data connections by uploading data connection details in CSV format, minimizing the risk of errors due to manual input.

Ensure you have all data connection details in CSV format that you want to create connections to data sources. If you are migrating from different Data Catalog instances, you can export data connection details in CSV format. For more information, see Export data connections.

Perform the following steps to import data connection details in Data Catalog:

1. Click Management in left navigation menu.

   The Manage Your Environment page opens.

2. In the Resources card, click Data Sources.

   The Manage Data Sources and Data Centers page opens.

3. Click Import.

   The Import Connections dialog box opens.

4. Upload the CSV file containing the data connection details and click Continue.

   It starts uploading the connections and configuring the data source connections. You can click View Workers and monitor the progress. For more information about tracking the progress, see Manage worker processes.

You have successfully imported the data connection details and configured data sources in Data Catalog.

You can also export data connections. See Export data connections for more information.