Importing a Data Source Configuration
Composer lets you import a data source configuration from another Composer instance. The import file must be a JSON file you previously downloaded. See Exporting a Data Source Configuration. Data source configurations can only be imported if the imported JSON file is from the same version of Composer.
The configuration settings that are imported include:
- The data source configuration name specified on the General Tab
- The data source connection settings specified on the Connection Tab
- The data tables selected for the configuration on the Tables/Indices Tab
- Custom labels, derived fields, and custom metrics specified on the Fields Tab
- The refresh settings set on the Refresh Tab
- Default visual settings set on the Visuals Tab
If you are logged into Composer as a user who can maintain data source configurations but cannot maintain connection definitions (your group privileges include Can Create new Data Sources, but notCan Manage Connections), the following data source import behavior occurs:
If the data store connection used by the data source has already been defined to the Composer instance, the data source is successfully imported.
If the data store connection used by the data source has not previously been defined to the Composer instance, the data source is not imported and an error message displays because your user account does not have authorization to create data store connections.
If you are logged in as a Composer administrator or as a user who can maintain both data source configurations and connection definitions (your group privileges include Can Create new Data Sources and Can Manage Connections), data source imports should work every time.
To import the data source configuration file:
Make sure you are logged in as a Composer administrator or as a user with Can Create new Data Sources group privileges.
On the Sources page, select . A pop-up Windows explorer window appears.
Browse for and select the JSON file for the data source configuration. Select Open on the Windows explorer dialog.
The data source configuration is imported. If a data source configuration already exists with the same name, the imported data source has a number appended to its name.
Import processing is depicted in the following diagram:
To be successfully imported to Composer, the data source configuration is validated against the following requirements. If one of them does not match, the import procedure will fail.
The version of Composer specified in the exported file must be the same as the version to which you are importing it.
Composer checks if there are any similar connections available (the connection name may be different). If the same connection is found in Composer, the connection is validated and a new data source is created using the available parameters.
If the same connection cannot be found, Composer validates if there are any related connection types available based on the following criteria:
- Minimum and maximum supported versions of the data sources
- Data store type
- Required parameters
If the connection types do not match the criteria listed above, the import process will stop. Otherwise, Composer creates the connection based on the first matching type.
Composer validates the connection with the parameters defined in the imported data source.
In case of successful validation, the connection is saved and the new data source is created.