Using the Data Provider for SAP with the DDEX Plug-in

If you chose to install the .NET Framework Data Provider for mySAP Business Suite along with the BizTalk Adapter Pack installation, the setup program installs a Visual Studio DDEX plug-in. You can use this plug-in to browse SAP objects using Visual Studio. This section provides information about using the DDEX plug-in.

You can use the plug-in to establish connectivity with the SAP system, add tables from the SAP system, and add function modules from the SAP system. After you have added the tables and function modules using the Visual Studio plug-in, the newly added tables and function modules are reflected in the SAPDiscoveredObjects.xml file. For more information about this file, see About the SAPDiscoveredObjects.xml File.

Make sure you chose to install the Data Provider for SAP along with the BizTalk Adapter Pack installation.

  1. Click Start, point to Programs, point to Microsoft Visual Studio 2005, and then click Microsoft Visual Studio 2005.

  2. In Visual Studio 2005, on the View menu, click Server Explorer.

  3. In the Server Explorer, right-click Data Connections, and select Add Connection.

  4. In the Change Data Source dialog box, from the Data source box, select <other>.

  5. From the Data provider drop-down list, select .NET Framework Data Provider for mySAP Business Suite and click OK. The Add Connection dialog box opens.

  6. The Add Connection dialog box lists the different connection parameters to connect to an SAP system. A typical connection string to connect to an SAP system using the Data Provider for SAP requires:

    • The connection parameters for a connection type. The Data Provider for SAP supports connection types A, B, and D. To connect to an SAP system you must provide connection parameters for any one of these connection types. For example, for connection type A, you must provide the name of the application server host and the system number.

    • The logon information to connect to an SAP system such as user name and password.

    For more information about the connection string to connect to an SAP system using the Data Provider for SAP, see The Data Provider for the SAP Connection String.

    In the Add Connection dialog box, specify:

    • The connection parameters for any one connection type.

    • The login information to connect to an SAP system.

    • Whether you want to enable SAP GUI debugging.

    • Whether you want to use RFC SDK tracing.

    Click OK. A new connection node is created under the Data Connections node with the server name you specified in the previous step.

  7. Expand the new connection node to view the Tables and Function Modules nodes.

    The following figure shows the Server Explorer after the connection is established.



    DDEX plug-in for SAP ADO.NET Provider

  1. In the Server Explorer, right-click the Tables node and click Search and Add Tables.

  2. In the Search table name text box, specify a search string to search tables in the SAP system, and click Search.

    Cc185172.note(en-US,BTS.10).gifNote
    The Data Provider for SAP supports the use of only the asterisk (*) wildcard character for searching tables.

  3. The Search results box lists the table names that satisfy the search criteria.



    DDEX plug-in Search and Add Tables name dialog box
  4. Select the check box corresponding to the tables you want to add and click Add. To select all the tables, click Select All. To clear all the selections, click Clear All.

  5. A dialog box informs you that the added tables would be visible after you refresh the Tables node. Click OK.

  6. Right-click the Tables node and select Refresh. The selected tables appear under the Tables node. Click a table name to see the table properties in the Properties pane.

  7. Expand a table name to see the fields for the table. Click a field name to see the field properties in the Properties pane.

  1. In the Server Explorer, right-click the Function Modules node and click Search and Add Function Modules.

  2. In the Search function module text box, specify a search string to search function modules in the SAP system, and click Search.

    Cc185172.note(en-US,BTS.10).gifNote
    The Data Provider for SAP supports the use of only the asterisk (*) wildcard character for searching functional modules.

  3. The Search results box lists the function modules that satisfy the search criteria.



    DDEX plug-in Search and Add Modules dialog box
  4. Select the check box corresponding to the function modules you want to add and click Add. To select all the modules, click Select All. To clear all the selections, click Clear All.

  5. A dialog box informs you that the added function modules would be visible after you refresh the Function Modules node. Click OK.

  6. Right-click the Function Modules node and select Refresh. The selected function modules appear under the Function Modules node. Click a function module name to see the properties in the Properties pane.

  7. Expand a function module name to see nodes for import, export, changing, and table parameters.

  8. Expand the Import node to list the import parameters for the function module. Similarly, expand the Export and Tables nodes to see the list of export and table parameters for the function module.

Show: