Chapter 4. Managing data sources
Decision 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 Decision 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 Decision Central.
Decision 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 Decision Central according to your requirements.
Procedure
- Log in to Decision Central.
-
Select Admin
Data Sources. The Data Sources Authoring page opens. - 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 the Version of the database driver.
- Click Finish to add the driver to Decision Central.
4.2. Editing a database driver
You can update the properties of a database driver from the Driver Definition pane.
Procedure
- Log in to Decision Central.
-
Select Admin
Data Sources. The Data Sources Authoring page opens. - In the DataSource Explorer pane, select the driver you want to edit. The Driver Definition pane lists the driver details.
- 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 to save the changes to the driver.
4.3. Deleting a database driver
You can remove database drivers from the Data Source Definition pane of Decision Central.
Procedure
- Log in to Decision Central.
-
Select Admin
Data Sources. The Data Sources Authoring page opens. - In the DataSource Explorer pane, select the driver you want to delete. The Data Source Definition pane lists the driver details.
- Click Remove.
- Click Delete to delete the driver.
4.4. Adding a data source
You can add a new data source to Decision Central from the Data Sources Authoring page.
Procedure
- Log in to Decision Central.
-
Select Admin
Data Sources. The Data Sources Authoring page opens. - In the DataSource Explorer pane, click Add DataSource. The New data source window opens.
- In the New data source window, enter the data source Name, database Connection URL, User and Password, and Driver.
- Click Test Connection to verify the connection to the database.
- Click Finish to add the data source to Decision Central.
4.5. Editing a data source
You can edit the properties of a data source and also test its connection to the database in Decision Central.
Procedure
- Log in to Decision Central.
-
Select Admin
Data Sources. The Data Sources Authoring page opens. - In the DataSource Explorer pane, click the data source you want to edit. The Data Source Definition pane lists the data source details.
- 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 to confirm the changes to the data source.
4.6. Deleting a data source
You can delete an existing data source from the DataSource Explorer pane in Decision Central.
Procedure
- Log in to Decision Central.
-
Select Admin
Data Sources. The Data Sources Authoring page opens. - In the DataSource Explorer pane, click the data source you want to delete. The Data Source Definition pane lists the data source details.
- Click Remove.
- Click Delete to confirm the deletion of the data source.