Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

IFlow for local SQL database server integrating using cloud connector

Dushyant_Garg
Explorer
‎2023 Oct 18 6:47 AM
1,335
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

  1. Go to JDBC Driver and add driver.

  2. Deploy the driver successfully.

  3. Go to JDBC Data Source and add.


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




  1. Deploy it.

  2. Create Package and Artifact and IFlow.

  3. Save and deploy it.

  4. Copy the endpoint in Overview/Manage Integration Content.

  5. Open Postman and paste the endpoint in URL.

  6. Check the response getting in postman the table content.


Thanks

Dushyant
3 Comments
Labels in this area
Popular Blog Posts