Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,646 questions
How to do full load of BSEG table from SAP ABAP oracle environment using SAP table connector
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 99%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DR
1
Reputation point
I'm new to SAP. Can anyone let me know how to implement full load for the BSEG table from SAP ABAP oracle environment using SAP table connector into Azure. As this table has huge volume of data , which field can be used to pull the historical data .
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator2022-02-24T22:11:57.61+00:00 Hello @DR ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is that you would want to do a full load of BSEG table from SAP ABAP Oracle environment using SAP table connector into Azure. And you would like to know which field is used to pull the full load.
SAP is not my expert areas but as per my understanding this sounds like more of question to SAP Community forum rather than here. Please correct me if I'm wrong.
If you would like to reach out to SAP community regarding this, here is the link - SAP Community
Also, you would like to move the table data to Azure, could you please tell us what Azure Service you are looking for?
Thanks
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2022-03-03T19:58:17.583+00:00 Hello @DR ,
Checking to see if you have got a chance to see my previous comment. If so, could you please share more details as requested to which Azure service you are using as Target? In case if you have already got help from SAP community, please do share the solution here as it would help others reading this thread.
Thank you
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2022-03-14T18:08:01.237+00:00 Hello @DR ,
We still have not heard back from you. Following up to see if you still need assistance on this query. In case if you have already found a solution, please do consider sharing it here with community, as it would be helpful for others reading this thread.
But as per my conversation with internal experts, we may not have much understanding on one specific table, but in generally, please use a column that able to make data evenly distributed, and make sure we do not have a huge of data which all have the same value of this partition column. For example, the row created date/month/year column, an incremental id column.
SAP connector or any ERP/APP/DW setups are quite complex for ant ETL/ELT tool. It is not possible to give exact/concrete answer for your ask. Kindly read SAP connector doc entirely and have SAP admin to set it up correctly.
If you are still blocked it would be better to open a support ticket so that one of the support engineers can take a deeper look at your requirement and provid guidance accordingly by involving relevant product feature owners.
Sign in to comment
Sign in to answer