IFlow for local SQL database server integrating using cloud connector

[Dushyant_Garg1]

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