Skip to Content

SAP ABAP IDoc connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to an SAP ABAP IDoc database server.

System requirements

Database server

SAP ABAP IDoc Database Server

Client web browser

  • Chrome TM 60 or newer

  • Firefox ® 55 or newer

  • Safari ® 11.0.2 or newer

Connection instructions

Adding a server

  1. Navigate to the App Builder IDE

  2. From the Connect menu, click on the Connect to your enterprise link

    attachment

  3. Click the Create button on the top left of the Data Servers panel. This will bring up the Add Server page.

Filling in credentials

To connect to an SAP ABAP IDoc server, provide the following information:

  • Name: An identifiable and unique server name

  • Type: Select SAP ABAP IDoc from the dropdown menu

  • Hostname: Enter the hostname of the SAP ABAP IDoc database.

  • System Id or R3 Name: Enter the System Id or R3 Name.

  • System No: Enter the System No.

  • Client: Enter the Client.

  • User Name: The user name with which you access the database server

  • Password: The password associated with the above user name

  • Staging Data Source: Select a Data Source to be used to stage BAPI or IDOC data before posting.

C:\Users\Richard\AppData\Roaming\PixelMetrics\CaptureWiz\Temp\21.png

After filling in all necessary credentials, click the Save button to save the settings.

Testing the connection

  1. Click the Test Connection button beneath the server information to make sure the server is properly connected.

  2. Upon successful connection, click the App Builder IDE menu heading at the top of the page to return to the App Builder IDE.

Import a data source

After the server settings have been saved, the database needs to be connected to App Builder. Databases that are connected to App Builder are referred to as a data source.

  1. Navigate to the App Builder IDE.

  2. Click the Build your application link from the Build menu.

  3. Click the Data Storage Layer link, then Create a new data source record.

    1. Some data sources are automatically imported to the App Builder data storage page. If the data source has already been added, click on the associated Pop-Up icon to bring up the details page.

    2. Import Pattern: This allows users to import only certain tables by listing them in the box. Prefixes can also be used to only import a subset of tables (for example, MyApp_* will only import tables that start with "MyApp_"). If the space is left blank, it will import all tables.

    attachment

  4. Click Save to update the data source settings.

  5. Once the page refreshes, click the Import button that appears below the source credentials. When prompted, click Proceed. The import will be scheduled to run in the background.

    attachment