DatabaseQuery Component - How to use "connection url" property in DatabaseQuery Component in Matillion ETL?

Hi All,

I am facing issue in  "connection url" property in DatabaseQuery Component in Matillion ETL tool.

I using SAP free trial source system and using hostname , port and database name from sap hana cockpit and database explorer, but getting issue connection timed out.

jdbc:sap://ServerIP:Port/?databaseName=<dbname>

can you help with any solution?

Hello @banerjeeaniruddh2

Thanks for your post, I can see you raised another post after this regarding the same subject, I will pop a reply on there for you with an answer to your query, I am just chasing this with our team here at Matillion.

Kind regards, Joe

Hi @JoeCommunityManager​ , This issue is resolved thank you.

Amazing news,

 

If you need anything else, please let us know :)

yes sure @JoeCommunityManager​ , I have query related to ODP extract component which I have mentioned in my latest post.

can you please look into that.