Can anyone please let me know if Microsoft Connector 1.1 supports SAP 7.x (specifically 7.3) DataSource or not?

The Microsoft® SQL Server® 2008 R2 Feature Pack says: The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system http://www.microsoft.com/download/en/confirmation.aspx?id=16978MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

The Microsoft® SQL Server® 2008 R2 Feature Pack says: The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system http://www.microsoft.com/download/en/confirmation.aspx?id=16978MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

We are able to connect and map the table from BW but the process does not bring over any of the rows populated via the SAP Process Chain. Any help or insight would be greatly appreciated. SQL Version: SQL 2008 R2 + SP1 / Microsoft Connector 1.1 for SAP BW I have verified all of the following requirements for using the Microsoft Connector 1.1 for SAP BW: OK - Windows Server 2003 and later, Windows Vista, or Microsoft Windows XP Professional with Service Pack 2. OK - SQL Server 2008 Integration Services. Microsoft Connector 1.1 for SAP BW needs to be installed on the same computer where Integration Services is installed. OK - Windows Installer 4.5 and later. OK - Extracting data using Microsoft Connector 1.1 for SAP BW from SAP BI system requires the SAP Open Hub license. For more information about SAP licensing, consult your SAP representative. OK - On the SAP BI system, SAP_BW component support package level 16 (as part of SAP NetWeaver Support Pack Stack 14) is required. SAP_BW component support package level 17 or higher is strongly recommended. OK - To use Microsoft Connector 1.1 for SAP BW in 32-bit (64-bit) mode on any 32-bit (64-bit) operating system, The 32-bit (64-bit) version of librfc32.dll needs to copied to the following location: %windir%\system32. N/A -To use Microsoft Connector 1.1 for SAP BW in 32-bit mode on a 64-bit operating system, the 32-bit librfc32.dll needs to be copied to the following location: %windir%\SysWow64. What we know: In SAP they defined a simple process chain ( select f1, f2, etc. from Table_a - table_a has 32K rows ) Using the new BI Connector we setup a data flow task that uses the "SAP BW Source", We can see the table structure and the test of the connection succeedsm and map source/target. We have verified that the SAP Process Chain is getting executed The temporary table that is defined on the SAP side is getting loaded with the 32000 rows of data ( confirmed by the BASIS team ) NOTE: The BASIS team was able to go into SAP and select the data from the table using our ID The data never gets to us ( see the results below ) and it has been confirmed that the two ports can talk. SSIS Output: SSIS package "Test_SAP_RemoteSQLSRVR.dtsx" starting. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x3E8 at Data Flow Task, SAP BW Source: Process Start Process, variant Trigger Open hub ZOH_POS for SQL Interface has status Completed (instance 4OOO29EJ7YWPHMN46BB1BFMZ8) Information: 0x3E8 at Data Flow Task, SAP BW Source: Process Data Transfer Process, variant ZCDPOSCP -> ZOH_POS_FULL LOAD has status Active (instance DTPR_4OOO29M7QXIF096KC5DDLHLP0) Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is waiting for a notification. Information: 0x3E8 at Data Flow Task, SAP BW Source: A notification was received., RequestID=268507; NumberOfRows=33060; NumberOfPackets=1; OHS Destination=ZOH_POS Information: 0x3E8 at Data Flow Task, SAP BW Source: The extraction process is finished. Information: 0x3E8 at Data Flow Task, SAP BW Source: Number of rows: 33060. Information: 0x3E8 at Data Flow Task, SAP BW Source: Number of packets: 1. Information: 0x3E8 at Data Flow Task, SAP BW Source: RequestID: 268507 Information: 0x3E8 at Data Flow Task, SAP BW Source: OHS Metadata validation passed. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry. Information: 0x3E8 at Data Flow Task, SAP BW Source: Current status of process chain "ZADHOC_SQL_OPEN_HUP" is: A. Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now retrieving PacketID, "1". Information: 0x3E8 at Data Flow Task, SAP BW Source: The component is now processing an incoming packet that contains 0 rows. Error: 0x3E8 at Data Flow Task, SAP BW Source: Fatal error during reading of database Information: 0x3E8 at Data Flow Task, SAP BW Source: Wait for 20000 seconds and retry.

You need to patch the Microsoft.SqlServer.SapBiComponents.dll see http://blogs.msdn.com/b/debarchan/archive/2009/09/02/ssis-sap-bi-connector-1-0.aspx for more detailsArthur My Blog

You need to patch the Microsoft.SqlServer.SapBiComponents.dll see http://blogs.msdn.com/b/debarchan/archive/2009/09/02/ssis-sap-bi-connector-1-0.aspx for more detailsArthur My Blog

The updated URL for the blog post referenced above is http://blogs.msdn.com/b/debarchan/archive/2009/09/02/ssis-sap-bi-connector-1-0.aspx .Carla Sabotta

The updated URL for the blog post referenced above is http://blogs.msdn.com/b/debarchan/archive/2009/09/02/ssis-sap-bi-connector-1-0.aspx .Carla Sabotta

We are running 2008 R2 + SP1 - 10.50.2500

We are running 2008 R2 + SP1 - 10.50.2500

In that case, have you considered installing the newer version of the connector (Microsoft® Connector 1.1 for SAP BW)? http://www.microsoft.com/download/en/details.aspx?id=16978Carla Sabotta

In that case, have you considered installing the newer version of the connector (Microsoft® Connector 1.1 for SAP BW)? http://www.microsoft.com/download/en/details.aspx?id=16978Carla Sabotta

I apologize for the confusion, we are using the Microsoft® Connector 1.1 for SAP BW. I have gone back an updated the post to reflect this. Any ideas on where to possibly look next? I appreciate your help.

I apologize for the confusion, we are using the Microsoft® Connector 1.1 for SAP BW. I have gone back an updated the post to reflect this. Any ideas on where to possibly look next? I appreciate your help.

Have you confirmed that the version of the Microsoft.SqlServer.SapBiComponents.dll is 10.0.2729.0?Carla Sabotta

Have you confirmed that the version of the Microsoft.SqlServer.SapBiComponents.dll is 10.0.2729.0?Carla Sabotta

I do not see any reference to this version number on the dll. I have checked and on each install I have the following information:

I do not see any reference to this version number on the dll. I have checked and on each install I have the following information:

I'll investigate this further.Carla Sabotta

I'll investigate this further.Carla Sabotta

yes correct, but it is not working as per the document, we had to create a 3.5 objects in 7.3 version of SAP and then made to work.

This could be a time-out issue on the SAP side, while retrieving the data. Have you tried increasing the value of the Timeout property (Advanced Page in the SAP BW Source Editor dialog). Note, that the Timeout property setting is valid only if you've selected W - Wait for Notify as the value of the Execution Mode.Carla Sabotta

This could be a time-out issue on the SAP side, while retrieving the data. Have you tried increasing the value of the Timeout property (Advanced Page in the SAP BW Source Editor dialog). Note, that the Timeout property setting is valid only if you've selected W - Wait for Notify as the value of the Execution Mode.Carla Sabotta

We are using P - Process Chain as the setting for the execution mode.Dan Tichy

We are using P - Process Chain as the setting for the execution mode.Dan Tichy

The Using SQL Server 2008 Integration Services with SAP BI 7.0 article on MSDN mentions the possibility of timeout errors during the Open Hub DTP extraction through the connector, and provides the following guidance. "By default, SAP BI sets the number of parallel DTP processes as a value greater than 1 for performance reasons. This is configurable through SAP transaction code RSBATCH (SAP BI Background Management). Figure 5: Configuring Parallel Processing in SAP BI We want to keep the number of parallel processes to a reasonable value for the overall DTP process type DTP_LOAD, but this parallelism can lead to a timeout error during the Open Hub DTP extraction through Microsoft Connector for SAP BI. To get around this issue, the number of processes for the Open Hub DTP should be set to 1 by following the steps below" ...Carla Sabotta

I have passed this information along to the SAP Team, I will let you know.Dan Tichy

I have passed this information along to the SAP Team, I will let you know.Dan Tichy

I have passed this information along to the SAP Team, I will let you know. Dan Tichy Any resolution on this? We are facing the same problem with the totalWidth error. Interestingly enough, the process will complete successfully if there are zero rows in the process chain result. We are also running 2008 R2 64bit. SAP 7.1. Microsoft.SqlServer.SapBiComponents.dll is dated 3/30/09 version 10.0.2531.0. We are running connector 1.0. Should we be on 1.1? If so, where is it? Also, I've read where I need to patch Microsoft.SqlServer.SapBiComponents.dll, but all I see are MSI packs for 2008 (non-R2). How do we patch this for R2? Thanks, --Matt

I have passed this information along to the SAP Team, I will let you know. Dan Tichy Any resolution on this? We are facing the same problem with the totalWidth error. Interestingly enough, the process will complete successfully if there are zero rows in the process chain result. We are also running 2008 R2 64bit. SAP 7.1. Microsoft.SqlServer.SapBiComponents.dll is dated 3/30/09 version 10.0.2531.0. We are running connector 1.0. Should we be on 1.1? If so, where is it? Also, I've read where I need to patch Microsoft.SqlServer.SapBiComponents.dll, but all I see are MSI packs for 2008 (non-R2). How do we patch this for R2? Thanks, --Matt

Matt, We are still currently working through this issue. We have a support ticket open with microsoft which has been escalated. We are also working with the BASIS team on configuration. The connector install you are looking for can be found here: http://www.microsoft.com/download/en/details.aspx?id=16978 Microsoft Connector 1.1 for SAP BW for SQL Server 2008 R2 The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file. Audience(s): Partner, Developer X86 Package(SapBI.msi) X64 Package (SAPBI.msi) IA64 Package(SAPBI.msi) I hope this is what you are looking for. I will let you know if we make any progress. Please do the same. Thanks, Dan Dan Tichy

The Using SQL Server 2008 Integration Services with SAP BI 7.0 article on MSDN mentions the possibility of timeout errors during the Open Hub DTP extraction through the connector, and provides the following guidance. "By default, SAP BI sets the number of parallel DTP processes as a value greater than 1 for performance reasons. This is configurable through SAP transaction code RSBATCH (SAP BI Background Management). Figure 5: Configuring Parallel Processing in SAP BI We want to keep the number of parallel processes to a reasonable value for the overall DTP process type DTP_LOAD, but this parallelism can lead to a timeout error during the Open Hub DTP extraction through Microsoft Connector for SAP BI. To get around this issue, the number of processes for the Open Hub DTP should be set to 1 by following the steps below" ... Carla Sabotta Carla, We have confirmed that the Open Hub DTP is set to 1. So we can rule this out as being the issue. Dan Tichy

Matt, We are still currently working through this issue. We have a support ticket open with microsoft which has been escalated. We are also working with the BASIS team on configuration. The connector install you are looking for can be found here: http://www.microsoft.com/download/en/details.aspx?id=16978 Microsoft Connector 1.1 for SAP BW for SQL Server 2008 R2 The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file. Audience(s): Partner, Developer X86 Package(SapBI.msi) X64 Package (SAPBI.msi) IA64 Package(SAPBI.msi) I hope this is what you are looking for. I will let you know if we make any progress. Please do the same. Thanks, Dan Dan Tichy Thanks Dan. Great to hear they are working on it. We can get it working on XP (32bit) / SQL 2008 R2 (32bit) from my development workstation, but we are unable to make it work on Win Serv 08 R2 (64) / SQL 08 R2 (64). Also, the SapBI.msi package you referenced has a description of "Microsoft Connector for 1.1 for SAP BW". The one we have is "Microsoft Connector 1.0 for SAP BI". Do you know what SAP BW is? Will that work for our connect to BI? Keep in mind we currently are successful and pull records using my workstation using "1.0 for SAP BI". Thanks, will reply back if I make any headway. Our project is so urgently needing this SAP BI to SSIS functionality that we may spin up a VM with old Win 2003/32bit and SQL 2008R2 32bit just to play this one role of connecting, pulling data, and placing it on our production Win 2008R2/64 SQL 2008R2/64 servers. :P :)

Matt, We are still currently working through this issue. We have a support ticket open with microsoft which has been escalated. We are also working with the BASIS team on configuration. The connector install you are looking for can be found here: http://www.microsoft.com/download/en/details.aspx?id=16978 Microsoft Connector 1.1 for SAP BW for SQL Server 2008 R2 The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file. Audience(s): Partner, Developer X86 Package(SapBI.msi) X64 Package (SAPBI.msi) IA64 Package(SAPBI.msi) I hope this is what you are looking for. I will let you know if we make any progress. Please do the same. Thanks, Dan Dan Tichy Thanks Dan. Great to hear they are working on it. We can get it working on XP (32bit) / SQL 2008 R2 (32bit) from my development workstation, but we are unable to make it work on Win Serv 08 R2 (64) / SQL 08 R2 (64). Also, the SapBI.msi package you referenced has a description of "Microsoft Connector for 1.1 for SAP BW". The one we have is "Microsoft Connector 1.0 for SAP BI". Do you know what SAP BW is? Will that work for our connect to BI? Keep in mind we currently are successful and pull records using my workstation using "1.0 for SAP BI". Thanks, will reply back if I make any headway. Our project is so urgently needing this SAP BI to SSIS functionality that we may spin up a VM with old Win 2003/32bit and SQL 2008R2 32bit just to play this one role of connecting, pulling data, and placing it on our production Win 2008R2/64 SQL 2008R2/64 servers. :P :)

Matt, We are still currently working through this issue. We have a support ticket open with microsoft which has been escalated. We are also working with the BASIS team on configuration. The connector install you are looking for can be found here: http://www.microsoft.com/download/en/details.aspx?id=16978 Microsoft Connector 1.1 for SAP BW for SQL Server 2008 R2 The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file. Audience(s): Partner, Developer X86 Package(SapBI.msi) X64 Package (SAPBI.msi) IA64 Package(SAPBI.msi) I hope this is what you are looking for. I will let you know if we make any progress. Please do the same. Thanks, Dan Dan Tichy Thanks Dan. Great to hear they are working on it. We can get it working on XP (32bit) / SQL 2008 R2 (32bit) from my development workstation, but we are unable to make it work on Win Serv 08 R2 (64) / SQL 08 R2 (64). Also, the SapBI.msi package you referenced has a description of "Microsoft Connector for 1.1 for SAP BW". The one we have is "Microsoft Connector 1.0 for SAP BI". Do you know what SAP BW is? Will that work for our connect to BI? Keep in mind we currently are successful and pull records using my workstation using "1.0 for SAP BI". Thanks, will reply back if I make any headway. Our project is so urgently needing this SAP BI to SSIS functionality that we may spin up a VM with old Win 2003/32bit and SQL 2008R2 32bit just to play this one role of connecting, pulling data, and placing it on our production Win 2008R2/64 SQL 2008R2/64 servers. :P :) From what I understand the "Microsoft Connector 1.1 for SAP BW" is the newer version of "Microsoft Connector 1.0 for SAP BI" The requirements for both look to be almost identical if not completely identical. SAP BW to me means the data warehouse components of SAP Netweaver. I've heard the SAP warehouse referred to as SAP BI, SAP BIW, and SAP BW. Here is the white paper for the 1.0 Connector if you have not seen it already: http://msdn.microsoft.com/en-us/library/dd299430.aspx I will keep you posted. dtichy

Matt, We are still currently working through this issue. We have a support ticket open with microsoft which has been escalated. We are also working with the BASIS team on configuration. The connector install you are looking for can be found here: http://www.microsoft.com/download/en/details.aspx?id=16978 Microsoft Connector 1.1 for SAP BW for SQL Server 2008 R2 The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file. Audience(s): Partner, Developer X86 Package(SapBI.msi) X64 Package (SAPBI.msi) IA64 Package(SAPBI.msi) I hope this is what you are looking for. I will let you know if we make any progress. Please do the same. Thanks, Dan Dan Tichy Thanks Dan. Great to hear they are working on it. We can get it working on XP (32bit) / SQL 2008 R2 (32bit) from my development workstation, but we are unable to make it work on Win Serv 08 R2 (64) / SQL 08 R2 (64). Also, the SapBI.msi package you referenced has a description of "Microsoft Connector for 1.1 for SAP BW". The one we have is "Microsoft Connector 1.0 for SAP BI". Do you know what SAP BW is? Will that work for our connect to BI? Keep in mind we currently are successful and pull records using my workstation using "1.0 for SAP BI". Thanks, will reply back if I make any headway. Our project is so urgently needing this SAP BI to SSIS functionality that we may spin up a VM with old Win 2003/32bit and SQL 2008R2 32bit just to play this one role of connecting, pulling data, and placing it on our production Win 2008R2/64 SQL 2008R2/64 servers. :P :) From what I understand the "Microsoft Connector 1.1 for SAP BW" is the newer version of "Microsoft Connector 1.0 for SAP BI" The requirements for both look to be almost identical if not completely identical. SAP BW to me means the data warehouse components of SAP Netweaver. I've heard the SAP warehouse referred to as SAP BI, SAP BIW, and SAP BW. Here is the white paper for the 1.0 Connector if you have not seen it already: http://msdn.microsoft.com/en-us/library/dd299430.aspx I will keep you posted. dtichy

Hi, We are using SAP BW and Microsoft connector. With the connector, we are extracting data from BW standard dso. However, we are not able to extract deltas, as it sends us the change, before image and after image records i.e from the sap bw dso change log table. Can you advise, how to handle this. We are daily doing full loads from BW, which is over millions records. Thank you

Hi, We are using SAP BW and Microsoft connector. With the connector, we are extracting data from BW standard dso. However, we are not able to extract deltas, as it sends us the change, before image and after image records i.e from the sap bw dso change log table. Can you advise, how to handle this. We are daily doing full loads from BW, which is over millions records. Thank you

All Can someone help us to understand where do you register MSSAPBI_PROG(which is being maintained on SM59 isterd on Microsoft side or SAP BW side..? Any documentation on how to register would be helpful. Thanks