Chapter 22. 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. Note Business Central provides a default data source that can be used but cannot be edited or deleted. 22.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 . 22.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 . 22.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. 22.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 . 22.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 . 22.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 .

Commands: