|
|
Component: SQLPlus
|
|
Exports data from Database via SQL query to various formats of output.
|
Operations
|
Icon
|
Name
|
About
|
Link |
|
|
SQL to CSV
|
Exports data retrieved from executing SQL query into CSV format.
Why use it
- This operation is very useful in the scenario where you would like to export database table contents to a CSV file or in MS Excel format.
- This operation also allows you to convert the data types such as date, time or boolean value to different format in CSV file.
|
Properties |
|
|
SQL to Delimited Strings
|
Extracts data retrieved from executing SQL query into individual process variable per column as delimited string.
Why use it
- This operation is very useful in the scenario where you would like to export database table contents to a custom delimited string format.
- This operation lets you to extract database table contents on column basis delimited by the specified custom delimiter.
|
Properties |
|
|
SQL to Lists
|
Extracts data retrieved from executing SQL query into individual process variable per column as List.
Why use it
- This operation is very useful in the scenario where you would like to export database table contents to a list variable of a same column datatype.
|
Properties |
|
|
SQL to XML or Form Data
|
Inserts data retrieved from executing SQL query into XML or Form process variable.
Why use it
- This operation is very useful in the scenario where you would like to export database table contents to an XML format.
- A generated XML output can be used to populate form with some pre-filled information or populate a dropdown list with database values in the most cases.
|
Properties |
|
DOWNLOADS
DOCUMENTATION
|
|
Products
LiveCycle ES Components Installer
Business Process Techniques and Patterns