Add data source

To add the data source, you should select the connection type and pass the connection information.

Name: the database name used in the Codejig Builder.

Connection type: Direct or Proxy. See the “Difference between Direct and Proxy connection type” section for details.

Connection identifier (for Proxy): generate an ID for the Proxy connection.

Server type and Version: select your database if it is supported.

Server and Port (for  Direct connection): URL and port of the database.

Database: database name.

Username and Password: auth data.

Import the database into codejig application

If you have a database connection established and tested, you can import the data from your database table into the Codejig application.

In the Data source table view, unfold the source menu and click on the “Import” option.

After that, you need to check the dependencies to avoid conflicts.

After the import has been completed, you will see all the imported data types marked as “External”.

Test connection

Make sure your connectivity is successful using the Test connection feature.

Add a Primary Key to external type

A Primary Key can be created from the existing field of an external data type.

Start editing the field from the external type details view. Put a tick on the Primary key checkbox.

Note:  the Primary key field should contain a unique value that identifies each type of instance/row in the DB table.

Add an external Data type

You must have the defined data source to add an External type,

You can add the External type from the Data sources page:

After that, fill in the type name and select the data source.