Edit

Share via

About the Data Provider for Siebel

  • Article

Overview

The Data Provider for Siebel is built on top of the Microsoft BizTalk Adapter for Siebel eBusiness Applications. You can use the Data Provider for Siebel to:

  • Write an ADO.NET client to connect to the Siebel system. The Data Provider for Siebel exposes certain classes that enable you to interface with the provider.

  • Run a SELECT query on a Siebel business component

  • Run an EXEC query on a Siebel business service

  • Use the Data Provider for Siebel with SQL Server Integration Services (SSIS)

Use the .NET Framework Data Provider for Siebel eBusiness Applications is a great resource for information on:

  • The ADO.NET interfaces extended by the Data Provider for Siebel

  • The connection string to connect to a Siebel system

  • Syntax for the SELECT and EXEC statements

  • Using the Data Provider for Siebel with SSIS

Limitations

The following are known limitations of the .NET Framework Data Provider for Siebel eBusiness Applications:

  • The Data Provider for Siebel supports alias names for tables in the SELECT clause, but not in the WHERE clause.

  • The Data Provider for Siebel fails to create a table with column names that have the special character, "]". You can escape the special character by including another closing square bracket. So, you should include"]]" instead of "]".

  • Due to issues with timeout handling by the underlying Siebel client API, the Data Provider for Siebel does not support command and connection timeout.

  • The Data Provider for Siebel does not support asynchronous command behavior.

  • When used with a SQL Server Integration Services (SSIS) project, the Data Provider for Siebel fails to retrieve data for columns that contain values with more than 8000 characters. This is due to an SSIS restriction according to which:

    • Values greater than 4000 characters in SSIS variable are not supported.

    • Values greater than 4000 wide characters are not supported.

    • Values greater than 8000 single-byte characters are not supported.

  • The EXEC operation will not be functional while using the .NET Framework Data Provider for Siebel eBusiness Applications with SQL Server Integration Services (SSIS). So, for example, adapter clients will not be able to execute a business service in Siebel (using Data Provider for Siebel) while using the data providers with SSIS.

See also

Limitations of the Siebel adapter
Troubleshoot the Siebel adapter