Data Sources
This is the definition screen used to register the database on which the Workcube system runs, the databases that will be used to transfer data to Workcube, or other databases with which the Workcube database model is to be compared, to Workcube and Application Server (CF or Lucee, Tomcat) systems.
Path: System > DEV Tools > Data Source
Attention: All functions related to Dev Tools should only be used by system administrators and Workcube experts. It is unnecessary for normal users to access such pages. Only certain users should have authorization for this module, functions, transactions and processes.
How to Register a Data Source?
Note:The name of the database to which the Workcube system is connected also represents the main DSN information.

- DSN: The DSN name of the system is taken from the System Parameter Settings page and entered into this field.
- Type: The business software to which the data source connection is to be made is selected.
- Driver: Sql driver information of the data source. should be selected. Workcube generally runs on Microsoft SQL Server.
- IP: The IP information of the data source must be entered. The IP address is found in the "database_host" field on the System Parameter Settings page.
- Port: The port information of the data source must be entered. The port must be open to the server that will provide access. The port address is accessed from the database_port field in the System Parameter settings. Microsoft SQL Server uses the default port number 1433. However, sometimes ports may be changed for security reasons. Systems using Postgre enter the Postgre Port.
- Your Username: It is a fully authorized SQL user to the data source. If the data source is another Workcube system, the username must be the same as the DSN name. In other words, the DSN name defined in the first field should be written exactly as it is.
- Password: It is the password of the SQL user with full authority to the data source.
- CF Password: It is the password for ColdFusion or Lucee running on Apache Tomcat.
- Description: If you want to add a description to this data source, use this field.
Note: In order to upgrade, patch or pull, the release model database must be added as a data source.
Feedback
This is the definition screen used to register the databases that will be used to transfer data to Workcube or other databases with which the Workcube database model needs to be compared to Workcube and Application Server (CF or Lucee, Tomcat) systems.