on 06-07-2018 11:11 PM
Hello,
We have a HANA system which we're using as a Data Warehouse. We have configured the ABAP Agent as we wish to pull data in real time using BW extractors from our source ECC system using the ODP framework.
We have been successful in initializing the load, but what we've noticed is that there is a 20 minute lag from the time a change happens in the extractor, to when it gets picked up and loaded into HANA.
Since we want the extractor load via ODP to be real time, I was wondering if there was a setting somewhere that defines the pull frequency into HANA, or if I possibly missed something when configuring the agent or specific extractor pull.
Appreciate your support.
Marcelo
There are LO extractors and other extractors whose delta update intervals have to be configured to populate the queue. It is NOT correct to assume that delta records always can be instantly ready to be consumed at the moment the transaction occurs. Please look into the configurations of your extractors or data sources.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chun,
I didn't provide context around which extractors we're using, but for now we're using master data ATTR and TEXT datasources. Haven't touched any LO datasources as of yet.
But are you saying that this 20 minute delay is purely on the datasource side, or is it a combination of both datasource + SDI?
Thanks,
Marcelo
Well, in this case, it's not what I speculated in my previous reply, as your data sources are just those normal master data ones. I suggest you taking a look at ROOSOURCE table for your data sources, and inspect the field DELTASAFE2, which is for upper limit of safety interval. If there is value in this field, it means that each delta extract will run till the timestamp of current_time - deltasafe2.
If this field is empty, then it's difficult to analyze through such brief description in the forum, without looking into the system. You may have to run trace, or just write up an OSS message.
Apologies for not replying earlier. I will look into your suggestions here and see what I find. Unfortunately we've faced other roadblocks so we're switching entirely to SLT, so we might not face these issues there. I will keep you posted.
I appreciate you taking the time to provide valuable input.
Thanks,
Marcelo
Hi,
Let me understand: from one side you have HANA.
Is HANA as database and WH, or HANA is a database only and there is BW over that HANA?
BR,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrey,
Our landscape is ECC on MSSQL -> HANA DB
We don't have BW, we're using HANA as a DW, so using calculation views to create models to be exposed for reporting on the frontend (BOBJ).
Thanks,
Marcelo
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.