IFlow for local SQL database server integrating using cloud connector
2023-10-18 13:47:29 Author: blogs.sap.com(查看原文) 阅读量:8 收藏

Business Trends

Author's profile photo DUSHYANT GARG

October 18, 2023 2 minute read

0 0 14

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

Alerting is not available for unauthorized users

Assigned Tags

      Be the first to leave a comment

      You must be Logged on to comment or reply to a post.


      文章来源: https://blogs.sap.com/2023/10/18/iflow-for-local-sql-database-server-integrating-using-cloud-connector/
      如有侵权请联系:admin#unsafe.sh