CPI connectivity with PostgreSQL on-prem using Cloud Connector

[former_member802816]

CPI connectivity with MS SQL Server on-prem using Cloud Connector

I tried to connect on-prem PostgreSQL server on cloud environment. but I got problem "Error while getting Datasource Service: ServiceReference is null".

Step 1: Configure the cloud connector. and virtual host is "testdev:5433"

Step 2: Configure the JDBC Material

Step 3: Configure the iFlow with the TEST_POSTGRES

Step 4: Deploy the flow and test

Finally I got the "ServiceReference is null" error.

Hope team kindly help me to solve it.

Best Regards,

Gary

[griveraa]

Apparently "postgresql" is a reserved word, we had the same problem and it worked when we changed the virtual host from postgresql to posgressql2.

Hope it helps

[joel_langoyan]

Hi loveping0215

Just want to know if you gotten around this or is it not really feasible? Thanks.

Regards,

Joel

[former_member802816]

Hi Joel,

No progress for this issue.

Best Regards,

Gary

[Sriprasadsbhat]

Hello Gary,

Could you please try redeploying JDBC data store and then redeploy the Iflow ( pls undeploy & then deploy it ).Also from SAP Help documentation I could see PostgreSQL onpremise is not yet supported.

https://help.sap.com/docs/CLOUD_INTEGRATION/368c481cd6954bdfa5d0435479fd4eaf/88be64412f1b46d684dfba1...

Regards,

Sriprasad Shivaram Bhat

[former_member802816]

Hi Bhat,

Thank you very much.

PostgresSQL now only support cloud version.

and one more question, I tried to switch to use On-premise Oracle, and I'm using trial account, I got error:

also SQL Server driver, I also cannot upload, is it because trial account limitation?

Best Regards,

Gary