Pull data from SAP Tables using SSIS
-
Thursday, January 17, 2013 11:24 PM
Hi,
In my company we need to pull data from SAP Tables currently the process that we have is OMNI is a tool which pulls the data from SAP tables and load them in to files and we go to that place and pick them and load data in our our oracle tables. I want to know if there is any 3rd part tool or a free task that is available in market where we can install in our BIDS and pull data from the SAP Tables.
Top level we have right now :
SAP TABLES (With Data) -> OMINI (pulls data from SAP and make files)-> SSIS (Pull data from files and load in to Oracle Tables)
Needed :
SAP TABLES (With Data) -> SSIS (Need to connect SAP System(Tables) and pull data in to Oracle tables)
Thanks,
If any Question please let me know I will try my best to make my situation understand.
All Replies
-
Friday, January 18, 2013 1:40 AMModerator
To get data from SAP all you need is a Microsoft® Connectors v1.2 for Oracle http://www.microsoft.com/en-us/download/details.aspx?id=29284
Arthur My Blog
-
Saturday, January 19, 2013 6:24 AM
Check here. The adapters provided by Microsoft require SQL Server Enterprise edition.
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Monday, January 21, 2013 9:28 PM
COZYROC,
Thanks for the link its a great resource but I am looking for some free stuff where I don't have to pay I am not sure if my company will pay for this 3 rd party tool.
Xtract IS >Xtract IS BAPI
Is a perfect solution that I am looking for but it is associated with price I am not sure if my company will bring this 3rd party tool.
Xtract IS Licences
Enterprise License
6 months update subscription and support included
- Xtract IS Table
- Xtract IS Query
- Xtract IS BW Cube
- Xtract IS BAPIhttp://neudesic.com/theobald/en/order/xtractis.html
But Thanks for this resource this is a great one.
5400.00 USD Order Now [SSL] - Edited by Nag1234 Monday, January 21, 2013 10:22 PM
-
Monday, January 21, 2013 9:29 PM
Arthur,
I am not sure if you have understood my Question I am looking to connect SAP Tables not Oracle Table.
-
Monday, January 21, 2013 10:24 PM
Thanks for the link its a great resource but I am looking for some free stuff where I don't have to pay I am not sure if my company will pay for this 3 rd party tool.
Which version of SQL Server you are licensed? If you are licensed for the Enterprise edition, the adapters can be used for free.
There are no free adapters and you will not find any free stuff around. SAP asks for yearly fee to develop for their platform, which makes it impossible to deliver free stuff.
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Monday, January 21, 2013 10:52 PM
I am using the Enterprise one Here is what I am doing when I click http://msdn2.microsoft.com/en-us/library/ms141761.aspx
It takes me to a page where I am not sure how to download.
-
Monday, January 21, 2013 10:55 PM
You have to download it from here: http://msdn.microsoft.com/downloads/
That's what it states.
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Monday, January 21, 2013 10:59 PMI don't see any SAP Connectors on that website that I can download.
-
Monday, January 21, 2013 11:02 PM
I don't see any SAP Connectors on that website that I can download.
Most probably the downloads are available to MSDN subscribers. If you don't have MSDN account, you have to contact SQL Server support team directly and ask for assistance.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
- Proposed As Answer by ArthurZMVP, Moderator Thursday, January 24, 2013 4:26 PM
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, January 28, 2013 5:24 AM
-
Monday, January 21, 2013 11:48 PMThanks for all your information.
.png)
