Defining Data Sources (2.13)
Before any user can load data from a data source, that data source must be defined within InterSystems Data Studio™. The data source definition includes all the information needed to access the data source and retrieve information about the structure of available items in that data source.
Before creating a data source, ensure that you have created any required data source credentials. Many data source types require a credential for authentication, and you cannot complete the data source definition without one.
After defining a data source, you can use it to import schemas into the Data Catalog.
Defining a Data Source
To create a data source:
-
Click the Management
icon in the application menu. -
In the Data Loader section, click Data Sources .
The page then displays a list of the types of data sources .
-
Click one of the types.
The right area then displays a table of the data sources of that type.
-
Click the New Source button in the upper right, above that list.
-
In the right area, enter values as appropriate for that type .
-
Click Save .
Editing a Data Source
To edit a data source:
-
Click the Management
icon in the application menu. -
In the Data Loader section, click Data Sources .
The page then displays a list of the types of data sources .
-
Click one of the types.
The right area then displays a table of the data sources of that type.
-
Click the row for the data source that you want to edit.
-
In the right area, enter values as appropriate for that type .
-
Click Save .
Testing a Data Source
To test a data source:
-
Click the Management
icon in the application menu. -
In the Data Loader section, click Data Sources .
The page then displays a list of the types of data sources .
-
Click one of the types.
The right area then displays a table of the data sources of that type.
-
Click the Test Connection
icon in the row for the data source that you want to test.
If the test is successful, the system displays the message Connection test successful! at the top of the page.
If the test is not successful, the system displays a popup message indicating the connection failed.
Deleting a Data Source
To delete a data source:
-
Click the Management
icon in the application menu. -
In the Data Loader section, click Data Sources .
The page then displays a list of the types of data sources .
-
Click one of the types.
The right area then displays a table of the data sources of that type.
-
Click the Delete
icon in the row for the data source that you want to delete. The system displays a popup dialog box to confirm this action.
-
Click Delete .
When you delete a data source, the system automatically deletes any associated data schema definitions from the Data Catalog and (if applicable) removes its file interface path, including archived files.
