How to set up MySQL remote source through SDI

[SAPSupport]

I'd like to create a MySQL remote source via the CamelJDBCAdapter in SDI. I have a Data Provisioning Agent installed in a host machine.

Do I need to place the .jar files in this host and after that will the CamelJDBCAdapter display in the drop-down list of new remote sources?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

You can find more information about how to set up the Camel JDBC adapter here: Apache Camel JDBC.

You will have to place the appropriate .jar file (see our Product Area Matrix) in the <DPAgent_root>/camel/lib directory. You will also have to uncomment the configuration of the Camel adapter: Set up the Camel JDBC Adapter.

If you have not used this adapter before, you must register it with SAP HANA before you can use it: Register Adapters with SAP HANA.

After that, the adapter will appear in the drop-down list of adapters you can choose from and you can configure the MySQL remote source: Camel JDBC Remote Source Configuration. Finally, there are some special steps for MySQL which you'll need to be aware of: Connecting to MySQL with the Camel JDBC Adapter.

Best regards,
SAP Support