SAP HANA Direct ExtracHandledning för tor-anslutning (DXC)

Vad är SAP HANA DXC?

SAP HANA DXC är batchdriven datareplikeringsteknik, dvs den kan köras efter ett tidsintervall.

SAP HANA DXC använder befintlig ETL (ex.tract, Transformera och Ladda) metod för SAP Business Suite-applikation via en HTTPS-anslutning.

In SAP Innehåll i Business Suite-applikationen Datakälla Extractorer har varit tillgängliga för datamodellering och datainsamling för SAP Affärslager.

SAP DXC använder dessa datakällor t.ex.tractor för att leverera data direkt till SAP HANA.

Fördel av SAP DXC

• SAP DXC kräver ingen ytterligare server eller applikation i systemlandskapet.
• Det minskar komplexiteten i datamodellering SAP HANA, som den skickar data till SAP HANA efter att ha tillämpat alla affärsexklusivatractor-logik i källsystemet.
• Det går snabbare SAP HANA Implementering tidslinjer.
• Det extracsemantiskt rika data från SAP Business webbplats och ge till SAP HANA.

Begränsning av SAP DXC

• Datakälla måste ha fördefinierad ETL-metod, om inte måste vi definiera dem.
• SAP DXC kräver ett Business Suite-system på Net Weaver 7.0 eller högre (t.ex. ECC) lika med eller under SP-nivå: Release 700 SAPKW70021 (SP stack 19, från nov 2008).
• A procedure with a key field defined must exist in Data Source.

How DXC Works: Architecture and Data Flow

The advantage list above makes more sense once the flow is clear. DXC is unusual among provisioning methods because the transformation happens in the source system, not in HANA and not in a middleware layer.

Four components take part:

• The Business Suite source. An ECC or similar system holding the DataSource extractors originally written for BW. These already contain the business logic that turns raw tables into meaningful records.
• Exettracthor. When a load runs, the extractor reads the source tables, applies its logic, and produces a semantically complete record set rather than a raw table copy.
• The HTTPS connection. An RFC destination of type HTTP, created in SM59, carries the extracted data to the HANA XS engine. There is no separate replication server in the path.
• The IMDSO in HANA. The In Memory DataStore Object receives the data, applies record mode handling, and activates it into the target table.

This is what distinguishes DXC from table level replication. SLT copies a table as it stands, leaving the modeller to reconstruct the business meaning inside HANA. DXC delivers records that already carry that meaning, which is why it reduces modelling effort so noticeably. The trade off is latency, since extraction runs on a schedule rather than in real time.

Inställd SAP DXC DATA Replikering

Steg 1) Aktivera XS Engine och ICM Service

Enabling XS Engine. Gå till SAP HANA Studio -> Select System -> Configuration -> xsengine.ini.

Set instance value to 1 in the Default field.

Enabling ICM Web Dispatcher Service. It enables ICM Web Dispatcher service in HANA system. Web dispatcher uses ICM method for data read and loading in HANA system. Go to SAP HANA Studio -> Select System -> Configuration -> webdispatcher.ini

Set instance value to 1 in the Default column.

Steg 2) Installation SAP HANA Direct Extractor-anslutning

Ställ in DXC Connection SAP HANA – To create a DXC connection we need to import delivery unit in SAP HANA enligt nedan –

• Importleveransenhet. Du måste ladda ner DXC-leveransenheten från SAP in SAP HANA database. You can import the unit in the location “/usr/sap/HDB/SYS/global/hdb/content”. Import the delivery unit using Import Dialog in SAP HANA Content Node.
• Konfigurera XS Application Server för att använda DXC. Modify the application container value to libxsdxc (if any value existed, then append it).
• Kontrollera att DXC fungerar. We can check DXC Connection by using below path in a browser – http://<hostname>:80<instance Number>/sap/hana/dxc/dxc.xscfunc. Enter a user name and password to connect.
• User and Schema need to be defined in HANA Studio.
• HTTP connection in SAP BW for HANA needs to be defined through SM59.

So create a http connection in SAP BW Using T-code SM59. Input Parameters will be

• RFC Connection equal Name of RFC Connection
• Target Värd lika HANA Värdnamn
• Service Number equal 80 <Instance Number>

On the Log on Security tab, maintain the DXC user created in HANA Studio, which uses the basic authentication method.

Data Sources in BW need to be configured to replicate the structure to the HANA defined schema. We need to set up the following parameters in BW using program SAP_RSADMIN_MAINTAIN (T-code SE38 or SA38). The parameter list contains values which are passed to the call screen.

PSA_TO_HDB: This parameter accepts three object values as shown below –

• GLOBAL – This is used to replicate all data sources to HANA
• SYSTEM – It specifies clients to use DXC
• DATASOURCE – It specifies data sources, and only the specified ones can be used.

PSA_TO_HDB_DATASOURCETABLE: In this we need to give the table name, which holds the list of data sources used for DXC. In the VALUE field, enter the name of the table you created.

PSA_TO_HDB_DESTINATION: In this we need to move the incoming data. Enter the value created in SM59, here XC_HANA_CONNECTION_HANAS.

PSA_TO_HDB_SCHEMA: It specifies which schema the replicated data needs to be assigned to.

Datakälla replikering

Install data source in ECC using RSA5. we have taken data source 0FI_AA_20 (FI-AA: Transactions and Depreciation). First we need to Replicate the Meta data Using Specified application Component (data source version Need to 7.0 version. If we have 3.5 version data source, we need to migrate that first. Active the data Source in SAP BW).

Once data source loaded and activated in SAP BW, kommer det att skapa följande tabell i det definierade schemat.

• /BIC/A 00 – IMDSO Active Table
• /BIC/A 40 – IMDSO-aktiveringskö
• /BIC/A 70 – Hanteringstabell för inspelningsläge
• /BIC/A 80 – Tabell med information om begäran och paket-ID
• /BIC/A A0 – Begär tidsstämpeltabell
• RSODSO_IMOLOG – IMDSO-relaterad tabell. Lagrar information om alla datakällor relaterade till DXC.

Now data is successfully loaded into Table /BIC/A0FI_AA_2000 once it is activated. And we can preview data from table /BIC/A0FI_AA_2000 in SAP HANA Studio.

DXC vs SLT vs Data Services

DXC is one of three main routes into SAP HANA and is the most narrowly scoped of them. The comparison shows where each earns its place.

Parameter	DXC	SLT	SAP Datatjänster
Latens	Batch, on a schedule	Realtid eller schemalagd	Batch, on a schedule
Källsystem	SAP Endast Business Suite	SAP och icke-SAP databaser	Nästan vilken källa som helst
Extra landskap	Ingen	En SLT-server	Ett landskap för datatjänster
Business semantics	Preserved by the extractor	None, table level copy	Som utformat i jobbet
Modelling effort in HANA	Låg	Hög	Medium
Bäst för	Reusing proven BW extractor-logik	Operationell rapportering om livedata	Konsolidering av heterogena källor

In short, choose DXC when the extractors already exist and their logic is trusted, SLT when latency matters, and Datatjänster when sources are varied and transformation is complex. The full landscape of options is set out in the datatillhandahållande handledning.

Troubleshooting a DXC Connection

Configuration spans two systems and several layers, so failures are common on a first setup. These checks resolve most of them, in the order worth trying.

1. Testet URL returns nothing. The XS engine is not running. Confirm the instance value in xsengine.ini is set and the service has been restarted, then retest the dxc.xscfunc address.
2. Authentication fails at the test URL. The DXC user does not exist in HANA or lacks privileges on the target schema. It also needs basic authentication enabled, since the destination uses it.
3. SM59 connection test fails. Check the service number is 80 followed by the two digit instance number, and that the target host resolves from the BW system rather than only from your workstation.
4. Data loads but lands in the wrong schema. PSA_TO_HDB_SCHEMA names the target. If it is unset, the load falls back to a default that rarely matches expectation.
5. The data source is ignored. With PSA_TO_HDB set to DATASOURCE, only entries listed in the table named by PSA_TO_HDB_DATASOURCETABLE are replicated. A missing row silently excludes it.
6. Activation fails on the IMDSO. Almost always a missing key field. DXC requires a DataSource with a defined key, which is the third limitation listed earlier.
7. Exettractor is version 3.5. It must be migrated to 7.0 before DXC can consume it.

Table RSODSO_IMOLOG is the first place to look when diagnosing a load, because it records every data source registered for DXC along with its status.

Vanliga frågor