Export from database to Excel (1997-2003) using ODBC
<?xml version="1.0" encoding="UTF-8"?> <scenario> <name>Export from database to Excel (1997-2003) using ODBC</name> <script>move_to_excel_odbc</script> <driver>com.toolsverse.etl.driver.excel.ExcelOdbcDriver</driver> <sources> <source> <name>employee</name> <extract> <sql>select * from employee</sql> </extract> </source> </sources> <destinations> <destination> <name>employee</name> <tablename>employee_list</tablename> <metadata>yes</metadata> <load> <variables> <SALARY include="false" /> <BONUS include="false" /> <JOB code="var value;value = '\'NO JOB\'';" lang="JavaScript" /> </variables> </load> </destination> </destinations> </scenario>