Version 25.3.9414

• Prerequisites
• SAP ERP コネクタを追加
• 接続の確立
• Enabling CDC in CData Sync
• Enable SAP Custom Tables for CDC
  • Step 1: Create Your Custom Table and Data Elements with the Change Document Flag
  • Step 2: Create and Configure the Change Document Object
  • Step 3: Verify That Your Table Is Ready for CDC
• 詳細情報

CData Sync アプリケーションからSAP ERP コネクタを使用して、SAP ERP からデータを取得してサポートされている任意の同期先に移動できます。これを行うには、コネクタを追加し、コネクタへの認証を行い、接続を完了する必要があります。

Prerequisites

Before you can connect to SAP ERP, you must set up the following components:

1. Download the Software Developer Kit (SDK), based on your operating system, from SAP Java Connector.

2. Download the sapjco3.jar and sapjco3.dll files from the SDK, as follows:

   1. Open the SAP Java connector and select the Jco version that matches your platform.

   2. Click the download link. This action opens the login page.

   3. Login to the SAP site with a valid S-user identifier (Id).

   4. Download the package.

3. Copy the sapjco3.jar file to the /libs/ext folder in your application directory.

4. Copy the sapjco3.dll file (or, use libsapjco3.so if your Sync instance is on a Linux machine) to the /libs/ext folder in your application directory.

SAP ERP コネクタを追加

Sync でSAP ERP のデータを使用できるようにするには、まず以下の手順でコネクタを追加する必要があります。

1. Sync のダッシュボードから接続ページを開きます。

2. 接続を追加をクリックしてコネクタを選択ページを開きます。

3. データソースタブをクリックしてSAP ERP 行に移動します。

4. 行末にある接続を設定アイコンをクリックして、新しい接続ページを開きます。接続を設定アイコンが利用できない場合は、コネクタをダウンロードアイコンをクリックしてSAP ERP コネクタをインストールします。新規コネクタのインストールについて詳しくは、接続を参照してください。

接続の確立

Sync でSAP ERP のデータを使用するには、はじめにSAP ERP への接続を確立する必要があります。以下の手順で、SAP ERP をSync アカウントに接続します。

1. Sync のダッシュボードから接続 ページを開きます。

2. 接続を追加をクリックしてコネクタを選択ページを開きます。

3. データソースタブをクリックしてSAP ERP 行に移動します。

4. 行末にある接続を設定アイコンをクリックします。接続を設定アイコンが見当たらない場合は、接続の説明に従ってコネクタを追加する必要があります。

5. 設定タブで接続の設定を入力します。

   • Connection Name - Enter a connection name of your choice.

   • User - Enter the username that you use to authenticate to SAP ERP.

   • Password - Enter the password that you use to authenticate to the SAP ERP account.

   • Client - Enter the name of the client that you want to authenticate to the SAP system.

   • Connection Type - Select the connection type that you want to use. The default type is JCo.

   • Connection Scheme - Select the connection scheme that you want to use. The default scheme is ApplicationServer.

   • Host - Enter the host name of the target system. You can specify a regular host name, an IP address, or a SAP router address.

   • System Number - Select the number that defines the target system. The default value is 0.

6. 作成およびテストをクリックして接続を作成します。

7. 高度な設定タブで接続の高度な設定を定義します。（ただし、ほとんどの場合これらの設定は必要ありません。）

Enabling CDC in CData Sync

To configure your SAP ERP source connection to use CDC, follow these steps:

1. Open the Advanced tab of the SAP ERP source page and navigate to the Miscellaneous category.

2. Select ChangeDataCapture for the Table Mode property.

3. Click Create & Test to save your connection change.

4. Create a job in Sync using SAP ERP as your source and select Change Data Capture for the Type option.

Once you create a CDC job, the Tasks list shows only tables that are enabled for CDC. If you have custom tables that you want to appear in the Tasks list for the CDC job, you must enable them for tracking first in the SAP GUI. The following section explains how to enable such tables for tracking.

Enable SAP Custom Tables for CDC

To prepare SAP custom tables for use with CDC in Sync, perform the steps in the following sections.

Step 1: Create Your Custom Table and Data Elements with the Change Document Flag

In the SAP GUI, create a custom table, as follows:

1. Open SAP ERP and navigate to transaction SE11.

2. On the ABAP Dictionary: Initial Screen page, select the Database Table radio button and enter a name for your custom table (for example, ZMACHINES_TABLE) in the associated text box.

   Note: The initial Z in the name is required for custom objects in SAP ERP.

3. Click Create. This action opens the Create Table page.

4. On the Create Table page, enter a short description of your table (for example, Machines Table).

5. Click Technical Settings in the menu bar at the top of the window.

6. On the General Properties tab of the Dictionary: Define Technical Settings page:

   1. Select APPL0 in the Data Class list. This is the typical selection for master data and transparent application tables.

   2. Select the Log Data Changes checkbox and save your changes.

      

   3. Click Cancel to return to the previous page.

7. Click the Fields tab and follow these steps to create any new fields that you want.

   1. Enter a field name in the Fields column (for example, NEW_FIELD).

   2. Enter a name for the new element in the Data Element field. To create a custom data element, enter a name that starts with the letter Z (for example, ZNEWDATAELEMENT). SAP prompts you to create a new element if it does not already exist.

      

   3. Double-click the name that you entered. SAP will prompt you for additional configuration in other columns (Data Type, Length, and Description).

8. Activate the table by clicking the Activate icon in the menu bar.

   

Step 2: Create and Configure the Change Document Object

Follow these steps to create and configure a change document object (SCDO):

1. Open transaction SCDO.

2. Enter a name for your object (for example, ZMACHLOG) in the Object text box.

3. Click Create to create a new change document object and open the Create Object Directory Entry dialog box.

   

4. Select Local Object from the Package list. Provide a short description of the object (for example, “Change Document Object for Machines Tab”).

5. Click the Table tab to assign your custom table to your change document object.

   1. Add your table name (for example, ZMACHINES_TABLE).

   2. Select the Delete Documentation column and the Insert Documentation column, as shown below:

      

   3. Click the Save icon in the task bar at the top of the window.

6. Click Generate in the task bar.

7. In the Generate Update Pgm. dialog box, enter a name in the Function group text box (for example, ZMACHLOG_WRITE_DOCUMENT).

8. Click Generate at the bottom of the dialog box.

9. On the next page, double-click the name of your function group (ZMACHLOG_WRITE_DOCUMENT). This action takes you to transaction SE37.

   

   SAP generates a function module that is executed each time this object is involved. You might need to adapt the logic to handle the insertions, updates and deletions based on your scenario. You can modify this module, depending on your scenario.

10. Click the Validate icon () to check the module syntax.

11. Click the Activate icon () to activate the function module.

At this point, the infrastructure for change documents in SAP is in place. However, no entries are logged until the system-generated function module (ZMACHLOG_WRITE_DOCUMENT) is invoked. This invocation must occur within the application logic, update module, or custom program that modifies the table, ensuring that each change is explicitly captured and recorded.

Step 3: Verify That Your Table Is Ready for CDC

Now, you should verify that the target table is ready for change-document capture (CDC). This ensures that the system recognizes the SCDO object that you created and that subsequent changes will be logged correctly.

1. Open transaction SE16.

2. Enter the table name TCDOB.

   

3. On the Data Browser - Table TCDOB page, filter by entering ZMACHINES_TABLE in the TABNAME text box.

   Once you do this, you can see that the SCDO object you created is linked to your table and that it is ready to handle CDC.

   

詳細情報

CData Sync とSAP ERP の連携について、詳しくはSAP ERP Connector for CData Sync を参照してください。