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.
SQL component overview
Petals-BC-SQL Documentations
Contributors
No contributors found for: authors on selected page(s)
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 XSTL component.
When you are facing complex database manipulations, the ETL approach with the Talend component may be more useful.
E-mail
