3.1.2 jdbc Interpreter

Note:

This feature is not recommended approach because it can only be used to connect to a single schema, and all users will have access to that, rather than access being managed per user. In future releases this interpreter will not be enabled by default but instructions will be given to enable if required.

Limitation

• Data source configuration is not dynamic; instead, it is static from the Interpreter Configuration screen.
• There is no restriction or secure access of data provided with this interpreter.

Recommendation

Users are recommended to use a python interpreter to get dynamic data source configuration; even data access permission features can also be used with this interpreter.

The jdbc Interpreter is a ready-to-use interpreter used to connect Studio schema without OFSAA. This Interpreter is used to connect and write SQL queries on any schema without any restriction. The jdbc interpreter has no security attributes. It can be used to access any schema. In the jdbc interpreter, you can configure schema details, link Wallet Credentials to the jdbc Interpreter, etc.

Prerequisites

1. Navigate to <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmgstudio/ conf directory.
2. Open the application.yml file and update overwrite-builtin property as false.
3. Save the changes and close the application.yml file.
4. Restart Compliance Studio.