PyCharm 2019.3 Help

Managing data sources

Data source is a location of data for your application. In PyCharm, you can define the following data sources:

Create a data source

Create a DDL data source

  1. Open the Database tool window (View | Tool Windows| Database).

  2. Click the Data Source Properties icon (the Data Source Properties icon) on the toolbar, and select DDL Data Source.

  3. Specify the data source name.

  4. In the DDL Files form, click the Add icon (the Add icon) and select necessary SQL files.

Customizing data sources

Configure data source settings

  1. In the Database tool window (View | Tool Windows | Database), select a data source that you want to change.

  2. Click the Data Source Properties icon (the Data Source Properties) on the toolbar (or press Shift+Enter).

  3. In the Data Sources and Drivers window, edit the data source properties. For more information about data source properties, see Data source settings and DDL data source settings.

Group data sources

If you have a number of different databases, you can group their data sources in the Database tool window (View | Tool Windows | Database).

  1. To group data sources, select the necessary data source, press F6, or select Move to Group from the context menu.

  2. To create a new group, drag one data source onto the other. If you want to place the data source into an existing group, drag it to the existing group node.

  3. To remove a data source from the group, move the data source to the root list.

Remove data sources

To remove a data source, in the Database tool window (View | Tool Windows | Database), press Delete. Alternatively, you can select Remove from the context menu, or click Edit | Delete.

Also, to remove a data source, you can use the Data Sources and Drivers window (File | Data Sources). In the Data Sources and Drivers window, select the data source and press Delete. Alternatively, you can click the Remove icon on the toolbar, or select Remove from the context menu.

Last modified: 2 April 2020