Ce contenu n'est pas disponible dans la langue sélectionnée.
Chapter 27. Data source and database driver management
Business Central provides data source management features that enable you to define data sources for accessing a database. These data sources are then used by other Business Central components such as data sets. A database driver enables communication between a data source and the targeted database.
From the Data Source Authoring page you can add data sources and database drivers to Business Central.
Business Central provides a default data source that can be used but cannot be edited or deleted.
27.1. Adding a data source
You can add a new data source to Business Central from the Data Sources Authoring page.
Procedure
- In Business Central, select the Admin icon in the upper-right corner of the screen and select Data Sources.
In the DataSource Explorer pane, click Add DataSource.
The New data source window opens.
- In the New data source window, enter the Name, Connection URL, User, Password, and Driver fields of the data source.
- Click Test Connection to verify the connection to the database.
- Click Finish.
27.2. Editing a data source
You can edit the properties of a data source and also test its connection to the database in Business Central.
Procedure
- In Business Central, select the Admin icon in the upper-right corner of the screen and select Data Sources.
- In the DataSource Explorer pane, click the data source you want to edit.
- In the Data Source Definition pane, make the necessary changes to the Name, Connection URL, User, Password, and the Driver fields.
- Click Test Connection to verify the connection to the database.
- Click Update.
- Click Save.
27.3. Deleting a data source
You can delete an existing data source from the DataSource Explorer pane in Business Central.
Procedure
- In Business Central, select the Admin icon in the upper-right corner of the screen and select Data Sources.
- In the DataSource Explorer pane, click the data source you want to delete.
- Click Remove.
- Click Delete to confirm the deletion of the data source.
27.4. Adding a database driver
You can add a new database driver to Business Central.
Procedure
- In Business Central, select the Admin icon in the upper-right corner of the screen and select Data Sources.
In the DataSource Explorer pane, click Add Driver.
The New driver window opens.
- In the New driver window, enter the Name, Driver Class Name, Group Id, Artifact Id, and Version fields of the database driver.
- Click Finish.
27.5. Editing a database driver
You can edit the properties of a database driver from the Driver Definition pane.
Procedure
- In Business Central, select the Admin icon in the upper-right corner of the screen and select Data Sources.
- In the DataSource Explorer pane, select the driver you want to edit.
- In the Driver Definition pane, make the necessary changes to the Name, Driver Class Name, Group Id, Artifact Id, and the Version fields.
- Click Update.
- Click Yes.
27.6. Deleting a database driver
You can remove database drivers from the Data Source Definition pane of Business Central.
Procedure
- In Business Central, select the Admin icon in the upper-right corner of the screen and select Data Sources.
- In the DataSource Explorer pane, select the driver you want to delete.
- Click Remove.
- Click Delete.