-- ユーザー(スキーマ)作成
-- ※ <password> は、任意のパスワードで書き換えてください。
-- (英数字、大文字、小文字含む8文字以上の複雑なパスワード)
CREATE USER S4HANA PASSWORD <password>
NO FORCE_FIRST_PASSWORD_CHANGE SET USERGROUP DEFAULT;
-- 権限設定
GRANT CATALOG READ TO S4HANA;
GRANT CREATE SCHEMA TO S4HANA;
-- リモートソース作成用権限
GRANT CREATE REMOTE SOURCE TO S4HANA;
-- テクニカルユーザーのため、パスワードの失効期限の設定を無効 ※ 自社の運用/ポリシーに合わせて設定
ALTER USER S4HANA DISABLE PASSWORD LIFETIME;
-- ※ DBADMINで実行
-- DP Agent 管理者ユーザーの作成
CREATE USER DPA_ADMIN PASSWORD <password>
NO FORCE_FIRST_PASSWORD_CHANGE SET USERGROUP DEFAULT;
GRANT AGENT ADMIN TO DPA_ADMIN;
GRANT ADAPTER ADMIN TO DPA_ADMIN;
-- テクニカルユーザーのため、パスワードの失効期限の設定を無効 ※ 自社の運用/ポリシーに合わせて設定
ALTER USER DPA_ADMIN DISABLE PASSWORD LIFETIME;
-- ※ DBADMINで実行
-- DP Agent メッセージ用ユーザーの作成
CREATE USER DPA_MSG PASSWORD <password>
NO FORCE_FIRST_PASSWORD_CHANGE SET USERGROUP DEFAULT;
-- テクニカルユーザーのため、パスワードの失効期限の設定を無効
ALTER USER DPA_MSG DISABLE PASSWORD LIFETIME;
-- 仮想テーブル作成
CREATE VIRTUAL TABLE "S4HANA"."VT_CMMPOITMDX"
AT "S4HANA_SRC"."<NULL>"."<NULL>"."ABAP_CDS.CMMPOITMDX$F";
-- 仮想テーブル作成
CREATE VIRTUAL TABLE "S4HANA"."VT_CMMPURORGDX"
AT "S4HANA_SRC"."<NULL>"."<NULL>"."ABAP_CDS.CMMPURORGDX$P";
-- 仮想テーブルのレプリカの作成
alter virtual table "VT_CMMPOITMDX" add shared replica;
-- 仮想テーブルのレプリカの削除
alter virtual table "VT_CMMPOITMDX" drop replica;
-- 仮想テーブルのスナップショットの作成
alter virtual table "VT_CMMPURORGDX" add shared snapshot replica;
-- 仮想テーブルのスナップショットのリフレッシュ
alter virtual table "VT_CMMPURORGDX" refresh snapshot replica;
-- 仮想テーブルのスナップショットの削除
alter virtual table "VT_CMMPURORGDX" drop replica;
-- スキーマ名を条件に検索
select * from TABLES where SCHEMA_NAME = 'S4HANA';
select * from VIRTUAL_TABLE_REPLICAS where SOURCE_SCHEMA_NAME = 'S4HANA';
select * from M_VIRTUAL_TABLE_REPLICAS where SOURCE_SCHEMA_NAME = 'S4HANA';
C:\WINDOWS\system32>set DPA_INSTANCE=C:\usr\sap\dataprovagent01
C:\WINDOWS\system32>cd C:\usr\sap\dataprovagent01\bin
C:\usr\sap\dataprovagent01\bin>agentcli.bat --configAgent
Configuring the Agent at the following location:
C:\usr\sap\dataprovagent01
Initializing DPAgent Configuration Tool
************************************************************
DPAgent Configuration Tool
************************************************************
1. Agent Status
:
7. SAP HANA Connection
:
************************************************************
Enter Option:7
************************************************************
SAP HANA Connection
************************************************************
1. Connect to SAP HANA Cloud via JDBC
:
************************************************************
Enter Option:1
************************************************************
Connect to SAP HANA Cloud via JDBC
************************************************************
Press "Enter" button to keep default or skip an optional setting.
If a setting cannot be skipped, that means it is required.
************************************************************
Enter Use encrypted JDBC connection[true]: Valid options: true|false
true
Enter Host Name:
69ff52a4-c2e2-4914-abcdefghijklmn.hana.prod-jp10.hanacloud.ondemand.com
Enter Port Number:
443
Enter Agent Admin HANA User[DBADMIN]:
DPA_ADMIN
Enter Agent Admin HANA User Password:
Enter Agent Admin HANA User Password: (confirm)
Enter Use Proxy Server[false]: Valid options: true|false
false
Enter HANA User Name for Agent Messaging:
DPA_MSG
Enter HANA User Password for Agent Messaging:
Enter HANA User Password for Agent Messaging: (confirm)
Do you want to create a new SAP HANA user with the specified Agent XS HANA User credentials?
Enter [false] if the user already exists or [true] to create a new user.
false
Connecting to SAP HANA server via JDBC...
Agent configuration tool is connected to SAP HANA server via JDBC.
Press Enter to continue...
************************************************************
SAP HANA Connection
************************************************************
1. Connect to SAP HANA Cloud via JDBC
:
b. Back
************************************************************
Enter Option:b
Initializing DPAgent Configuration Tool
************************************************************
DPAgent Configuration Tool
************************************************************
:
8. Agent Registration
:
************************************************************
Enter Option:8
************************************************************
Agent Registration
************************************************************
1. Register Agent
:
************************************************************
Enter Option:1
************************************************************
Register Agent
************************************************************
Press "Enter" button to keep default or skip an optional setting.
If a setting cannot be skipped, that means it is required.
************************************************************
Enter Agent Name[dpagent_TYON347554abcdefg]:
SAPJPN011
Enter Agent Host Name[TYON347554abcdefg.xyz.xyz.com]:
TYON347554abcdefg.xyz.xyz.com
Registering agent 'SAPJPN011' with SAP HANA.
Agent 'SAPJPN01' successfully registered.
Press Enter to continue...
************************************************************
Agent Registration
************************************************************
:
b. Back
************************************************************
Enter Option:b
************************************************************
DPAgent Configuration Tool
************************************************************
:
9. Adapter Registration
:
************************************************************
Enter Option:9
************************************************************
Adapter Registration
************************************************************
1. Display Adapters
:
************************************************************
Enter Option:1
Number of Adapters: 26
Adapter Name Registered Custom Adapter
ABAPAdapter No No
:
:
HanaAdapter No No
:
:
Press Enter to continue...
************************************************************
Adapter Registration
************************************************************
:
2. Register Adapter
:
************************************************************
Enter Option:2
Enter adapter name:
ABAPAdapter
Adapter 'ABAPAdapter' successfully registered.
Press Enter to continue...
************************************************************
Adapter Registration
************************************************************
:
2. Register Adapter
:
************************************************************
Enter Option:2
Enter adapter name:
HanaAdapter
Adapter 'HanaAdapter' successfully registered.
Press Enter to continue...
************************************************************
Adapter Registration
************************************************************
1. Display Adapters
:
************************************************************
Enter Option:1
Number of Adapters: 26
Adapter Name Registered Custom Adapter
ABAPAdapter Yes No
:
:
HanaAdapter Yes No
:
:
Press Enter to continue...
************************************************************
Adapter Registration
************************************************************
1. Display Adapters
2. Register Adapter
3. Unregister Adapter
q. Quit
b. Back
************************************************************
Enter Option:q
2022-08-25 23:27:19,607 [ERROR] DPFramework | Message.write []
- Exception while writing to output stream: Connection reset by peer:
socket write error (local port 53916 to address 127.0.0.1, remote port 5051 to address 127.0.0.1)
Agent service daemon location: C:\usr\sap\dataprovagent01\bin\DPAgentServiceDaemon.exe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
19 | |
12 | |
11 | |
9 | |
8 | |
8 | |
7 | |
7 | |
7 | |
6 |