Skip to Content

SAP ABAP IDoc Sheets Vinyl Connection Guide 2.5

Overview

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

In order to connect your servers, you must have Vinyl 2.5 installed.

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 Vinyl 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 Vinyl IDE menu heading at the top of the page to return to the Vinyl IDE.

Import a Data Source

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

  1. Navigate to the Vinyl 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 Vinyl 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