Select a data source and configure a connection. Add code for the connection and then test the connection.
On the
Data Source Type
tab, select the data source from the list or search for a data source.
You can search for the data source from the list.
On the
Connections
tab, select an existing connection for the data source from the list, or create a new connection to the data source.
To create a new connection, click the + icon and configure the connection-specific properties for the data source that you want to connect to.
For example, if you configure a flat file connection, enter the directory where the files are stored, the date format for the date fields in the files, and the code page of the system that hosts the files.
The following image shows the properties that you need to configure for a flat file connection:
When you create and save a new connection, that connection displays in the connection list.
Select the required connection and perform one of the following actions:
To add the connection to the code cell, select the
icon, and provide a variable name for the connection to display in the Python code.
The selected connection is added to the Python code.
To test the connection, select the
icon.
The Python code for testing the selected connection displays. When you run the code, the test connection displays as successful.
To edit the connection, select the
icon, edit the connection details, and save the connection.