Petals Documentation > Petals ESB > Petals Components > Components User Guide > Petals-BC-SQL

Petals-BC-SQL

Features

The SQL component is a Binding Component which supports database connectivity through the Java Data Base Connectivity API (JDBC).
The component supports SQL instructions, restraint to Data Manipulation Language.
You can register and invoke stored procedures according to the JDBC driver and the database that you want to communicate with.

All attachment are processed by using XOP rules.(XML-binary Optimized Packaging : http://www.w3.org/TR/xop10/ )
Figure 1. SQL component mechanism
Petals-BC-SQL Documentations
Contributors
No contributors found for: authors on selected page(s)

Recommended Usage

The component can be use when basic data extraction/insertion must be done for your needs.
The XML form of the data manipulated is static, so the component demands XML adaptation, mostly done with the XSTL component.

When you are facing complex database manipulations, the ETL approach with the Talend component may be more useful.

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.