... Please click [here|SQLPlus DSC] for full reference on SQLPlus DSC.
h2. Using the Avoka SQL-Plus DSC
You can save data retrieved from a database as a CSV file.
The following process [sample|^sql_plus_csv_test.lca] demonstrates how to retrieve data from a database and save the data as a CSV file. You can import this archive file using archive manager and open it in the process designer.
First, we create a variable, called 'document_variable' of type 'document' and specify its properties as shown on the following picture.
\\
!doc_variable.jpg!
\\
The process workflow looks similar to the following.
\\
!csv_workflow.jpg!
\\
In the first step of the process we retrieve data from the database and save data formatted as a CSV file into the document variable. The following picture shows the settings to retrieve the data.
\\
!sql_info.jpg!
\\
Optionally, you can check the 'prepared SQL statement' box to create a prepared SQL statement and specify query parameters. To test your statement, click the 'Test' button. This will display the first row of the result set retrieved from the database.
The following picture shows settings to save data from the database into the document variable.
\\
!csv_info.jpg!
\\
Optionally, you can check the 'Use MS Excel CSV Format' box and 'Generate headers' box to use these options to format the data as a CSV file.
The second step in the process saves data from the document variable as a file in the local server directory.
After we run the process, we can open the file generated from the data and saved in the local server directory that should look like the one shown in the following picture.
\\
!doc_csv.jpg!
\\
This service is useful when you need to save data from a database as a CSV file. |
Retrieving data from a database and saving as CSV file
