Optional: Enabling the Liberty feature to integrate with SQL
To integrate with SQL in your Workflow starter pattern, update the Liberty configuration in your custom resource file.
Procedure
- Add any required JDBC driver or the files of the SQL Integration services to the BAStudio
container, by using the filestore persistent volume claim (PVC) that is mounted at
/opt/ibm/bawfile. Run the following command to copy your JDBC driver or the files of SQL Integration services to the BAStudio container location /opt/ibm/bawfile:
The files are stored in the persistent volume (PV) related to the PVC and are kept between restarts.oc cp jdbcdriver.file bastudio-pod:/opt/ibm/bawfile/jdbcdriver.file
- To add a datasource, customize the Liberty custom XML file by using the information from
Configuring relational database connectivity in Liberty and
Optional: Post-installation tasks for Business Automation Studio. The settings will be merged into the Liberty settings for the component. For more information about Liberty customization, see Administering Liberty manually.The XML snippet must be in the
<server>
element. The following example uses an SQL Server database.
The file path in the configuration must match the appropriate container path. The filestore PVC as described in the previous step is mounted at /opt/ibm/bawfile inside the container.<server> <dataSource id="DefaultDataSource" jndiName="jdbc/mssqlserver"> <jdbcDriver libraryRef="MSJDBCLib"/> <properties.microsoft.sqlserver databaseName="SAMPLEDB" serverName="9.x.x.x" portNumber="1433" user="<db-user>" password="<db-password>"/> </dataSource> <library id="MSJDBCLib"> <file name="/opt/ibm/bawfile/mssql-jdbc-9.4.1.jre8.jar"/> </library> </server>
-
After you modify the custom resource file, you must update your deployment to have it take
effect.
Follow the instructions in Updating script-installed deployments.