1. Configure the provider on KAWA
In the data source section:
- Click on “+” button and choose: “Connect to an external system” (#1 on schema)
- Then, click on “+ Connector ” button next to the data import section (#2 on schema)
- Pick the JDBC Custom provider (#3 on schema)
Enter the required connection details for your Oracle database:
- Fill in the name of your database
- Fill in the JDBC URL: jdbc:oracle:thin:user/******@hostname:port:SID
Here is a documentation about how to build the JDBC URL: https://docs.oracle.com/en/database/oracle/oracle-database/21/jajdb/index.html#:~:text=Examples%3A,mydbhost1%2Cmydbhost2%3A1521%2Fmydbservice
Click on Test Connection then Create.
You can import data either by picking a database and a table or by writing your own query
