View Source

{section}
{column}

h1. 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.
\\
\\
{center}*SQL component overview*
\\
!SQL.png|width=499,height=284!{center}
{column}

{column:width=25%}
{panel:title=Petals-BC-SQL Documentations}{children:all=true}{panel}
{panel:title=Contributors}{contributors:order=name|mode=list}{panel}
{column}
{section}


h1. Recommended Usage

The component can be used 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 XSLT component.

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