Export (0) Print
Expand All

SAP BI Source Editor (Advanced Page)

SQL Server 2008

Use the Advanced page of the SAP BI Source Editor to specify the string conversion rule and the time-out period, and also to reset the status of a particular Request ID.

To learn more about the SAP BI source component of the Microsoft Connector for SAP BI, see SAP BI Source.

The documentation for the Microsoft Connector for SAP BI assumes familiarity with the SAP NetWeaver BI environment. For more information about SAP NetWeaver BI, or for information about how to configure SAP NetWeaver BI objects and processes, see your SAP documentation.

Extracting data from SAP NetWeaver BI requires additional SAP licensing. Check with SAP to verify these requirements.

To open the Connection Manager page

  1. In Business Intelligence Development Studio, open the Integration Services package that contains the SAP BI source.
  2. On the Data Flow tab, double-click the SAP BI source.
  3. In the SAP BI Source Editor, click Advanced to open the Advanced page of the editor.

If you do not know all the values that are required to configure the source, you might have to ask your SAP administrator.

String Conversion

Specify the rule to apply for string conversion.

Option Description

Automatic string conversion

Convert all strings to nvarchar when the SAP NetWeaver BI system is a Unicode system. Otherwise, convert all strings to varchar.

Convert strings to varchar

Convert all strings to varchar.

Convert strings to nvarchar

Convert all strings to nvarchar.

Timeout (seconds)

Specify the maximum number of seconds that the source should wait.

This option is only valid if you have selected W - Wait for Notify as the value of Execution Mode on the Connection Manager page of the editor. For more information, see SAP BI Source Editor (Connection Manager Page).

Request ID

Specify the Request ID whose status you want to reset to "G - Green" when you click Reset.


Lets you reset the status of the specified Request ID to "G - Green", after prompting you for confirmation. This can be useful when a problem has occurred, and the SAP NetWeaver BI system has flagged the request with a yellow or red status.

© 2014 Microsoft