Integration with an database requires an administrator to set up database connections in the add-on. Additionally, the administrator must configure a connection between a database and an EBX® data model. This ensures that end users can only access the database tables that are approved data sources and targets for a given data model.
To successfully complete these tasks, start with the database connection information. This is a prerequisite for connecting a database and data model.
To connect to a database:
In the Administration panel, select TIBCO EBX® Data Exchange Add-on (New).
From the Reference data group, select the Databases table and create a new record.
Supply the required information:
Name: The name used to identify this connection.
URL: The URL used by the database for incoming connections. When using:
The External system authentication method, enter the URL for AWS.
The Direct authentication method, enter the URL specific to your database. For example:
MySQL: jdbc:sqlserver://<server>:<port>;databaseName=<databaseName>
Oracle: jdbc:oracle:<drivertype>:@<server>:<port>:<databaseName>
Postresql: jdbc:postgresql://<server>:<port>/<databaseName>
Authentication: Sets the authentication type for this connection. A direct connection uses a username and password; external system requires an access key.
Username and Password: The login credentials for this database connection.
Access key: The access key required to access the external database.
Optionally, test the connection.
Save and close.
This connection information is now available to use when connecting a database with a data model.
The option to import or export SQL is not available to end users until an administrator configures a connection between a database and a data model. To connect a database with a data model:
In the Administration panel, select TIBCO EBX® Data Exchange Add-on (New).
From the Reference data group, select Database to data model connections and create a new record.
Supply the following information:
Database: Select the database from the dropdown menu. This list populates with databases that you provided connection information for using the Databases table.
Data model: Select the data model to enable import and export between it and the selected database.
Optionally, provide a Table name pattern, Schema name pattern, and Description.
Save and close.
Users that have access to data in the specified data model can integrate data between the tables in the connected database and EBX®.