IFlow for local SQL database server integrating using cloud connector

Pre-requisite:

• Cloud Connector install in your system.
• SQL Server Management Studio working.
• BTP Cockpit

Steps:

1. Open Cloud Connector.
2. Login using credentials, enter details of BTP subaccount and save it.
3. Click on Cloud to on-premise button and add Mapping to Virtual system.
   
4. Check the server is reachable.
5. Login to your tenant.
6. Go to Monitoring -> JDBC Material.
7. Download below jar file.

https://go.microsoft.com/fwlink/?linkid=2137600

8. Go to JDBC Driver and add driver.
9. Deploy the driver successfully.
10. Go to JDBC Data Source and add.

JDBC URL: jdbc:sqlser://<virtualhost:port>;DatabaseName=<databasename>

11. Deploy it.
12. Create Package and Artifact and IFlow.
13. Save and deploy it.
14. Copy the endpoint in Overview/Manage Integration Content.
15. Open Postman and paste the endpoint in URL.
16. Check the response getting in postman the table content.

Thanks

Dushyant

Source link