Datarails Integrations solution is a paid plan that lets you consolidate all your data sources and seamlessly connect your external apps to the Datarails web app. For more information contact our integrations team here.

Following a schedule set by the user, the SAP B1 platform is queried. The results are stored as a CSV version in the target FileBox and can be used in DataRails like any other FileBox. 

Prerequisites 

• Access to Sap BTP Cockpit
• Admin access to DataRails to set up the integration between Datarails and SAP B1. The integration can be later shared with non-admin users. 

Data is only transferred from Sap B1 to Datarails.

The sync user does not write or modify any data in Sap B1, and therefore only requires list and view access .

Getting Started

Step 1: Acquire Your Credentials from SAP BTP Cockpit

1. Go to your SAP BTP Cockpit.
2. In your SAP Cockpit click on SAP HANA Cloud on the left panel.
   
3. Click on the Actions drop-down button under the Database Instance you wish to connect.
4. Choose the Copy SQL Endpoint and save it (it will be needed in the next stage).
   

Step 2: Create a Data Source in DataRails 

1. Go to Admin, then Data Sources. 
2. Click Add new data source.
   
3. In the Edit Data Source dialog, input the following: 
   
   • Organization: The customer's organization 
   • Type: Select SAPHANADB. 
   • Name: Enter a name for this integration (e.g. “SAP B1 integration”) 
   • Address: Paste the copied “Address” to the Address input in the Data source connection. Note, paste the address until the .com ends.
   • Port: port will be the number after the .com (e.g- f0590abd-4951-4ee5-84ac-7f312d717e2a.hana.trial-us10.hanacloud.ondemand.com:443)
   • User: Is the DB user name.
   • Password: The DB user password.
   • Key: If we use the Address we don’t need to input the Key.
4.  At the bottom of the screen, click Save.

Updated May 06, 2025 18:32