Red Hat Training

A Red Hat training course is available for Red Hat Process Automation Manager

Chapter 4. Managing data sources

Business Central provides data source management which gives you the ability of defining data sources for accessing a database. These data sources are then used by other Business Central components such as the data sets. A database driver, on the other hand, is used for enabling 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 can be used but can neither be edited nor deleted.

4.1. Adding a database driver

You can add a new database driver to Business Central according to your requirements.

Procedure

  1. Log in to Business Central.
  2. Select Admin → Data Sources. The Data Sources Authoring page opens.
  3. In the DataSource Explorer pane, click Add Driver. The New driver window opens.
  4. In the New driver window, enter the Name, Driver Class Name, Group Id, Artifact Id, and the Version of the database driver.
  5. Click Finish to add the driver to Business Central.

4.2. Deleting a database driver

You can remove database drivers from the Data Source Definition pane of Business Central.

Procedure

  1. Log in to Business Central.
  2. Select Admin → Data Sources. The Data Sources Authoring page opens.
  3. In the DataSource Explorer pane, select the driver you want to delete. The Data Source Definition pane lists the driver details.
  4. Click Remove.
  5. Click Delete to delete the driver.

4.3. Adding a data source

You can add a new data source to Business Central from the Data Sources Authoring page.

Procedure

  1. Log in to Business Central.
  2. Select Admin → Data Sources. The Data Sources Authoring page opens.
  3. In the DataSource Explorer pane, click Add DataSource. The New data source window opens.
  4. In the New data source window, enter the data source Name, database Connection URL, User and Password, and Driver.
  5. Click Test Connection to verify the connection to the database.
  6. Click Finish to add the data source to Business Central.

4.4. 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

  1. Log in to Business Central.
  2. Select Admin → Data Sources. The Data Sources Authoring page opens.
  3. In the DataSource Explorer pane, click the data source you want to edit. The Data Source Definition pane lists the data source details.
  4. In the Data Source Definition pane, make the necessary changes to the Name, Connection URL, User, Password, and the Driver fields.
  5. Click Test Connection to verify the connection to the database.
  6. Click Update.
  7. Click Save to confirm the changes to the data source.

4.5. Deleting a data source

You can delete an existing data source from the DataSource Explorer pane in Business Central.

Procedure

  1. Log in to Business Central.
  2. Select Admin → Data Sources. The Data Sources Authoring page opens.
  3. In the DataSource Explorer pane, click the data source you want to delete. The Data Source Definition pane lists the data source details.
  4. Click Remove.
  5. Click Delete to confirm the deletion of the data source.