HANA-SQL task in EAConnect
This task extracts Data from HANA Database based on the Query provided in the task as parameter. The extracted data is converted to the format needed in the target system(CSV format) and stored in the EAConnect server as an intermediate staged data file. This data is consumed further in the next task in the EAConnect Flow and can be cleared from the intermediate Staging area.
¶ Prerequisite
A connection has been configured to HANA Database, and the connection test is active.
¶ Create HANA-SQL Task
1. Navigate to the Task section in EAConnect and create a new task
2. Enter the name and description. Select Task type ‘HANA Sql’ from the dropdown, Select the HANA Connection (created earlier under Connections) and Click save after all the information is entered.
The SQL can be repalced bay any Standard SQL as needed for the data requirement. replace ‘DB_SCHEMA’ with the schema name in the HANA DB replace “ANAPLAN_PRICES” with the table name needed for the query.
3. Verify the Task shows up under the HANA SQL Connection.
