You can import data from Oracle or Teradata to SQL Server using SSIS Connectors. To perform these operations you need to install the Oracle and Teradata connectors from microsoft at the following link
Connector Download Link
After installing the connectors, open the BIDS(VisualStudio)
open the ssis project and open the ssis package. Go to data flow items. Rigth click on Data Flow items on the context menu "Choose Items" In the Choose ToolBox Items window select "SSIS Data Flow Items" and select the check box for "ORACLE Source" and "Oracle Destination". For Teradata select the check box for "Teradata Source" and "Teradata Destination" and press ok.
Check the user forums for issues and updates
User Fourms
To connect to SAP BW from SSIS, install the Microsoft Connector 1.0 for SAP BI from the following location.
Microsoft Connector for SAP BI Download page
Download it from "Microsoft Connector 1.0 for SAP BI" in that page.
1 comment:
I have installed the Microsoft BI Connector 1.0 X64.The SSIS and SQL Server Installation are X64.
Apart from this I have installed the WCF LOB and Biztalk Adapter drivers.
I get an error on trying to extract data from tables.
I have followed the following tutorial too to connect but unable to get data
http://agilebi.com/jjames/2011/05/25/how-to-extract-sap-data-in-ssis/
Please let know on how to correctly configure and connect to the SAP system using SSIS to derive data from it
Thanks,
Narayana
Post a Comment