Forum Discussion

DomAlbrechtinSA's avatar
DomAlbrechtinSA
Copper Contributor
Jun 30, 2023

Exasol script scheduling using ADF

I am desperately looking for some advice from the community as I am out of options! 

 

I have an Exasol database and would like to use ADF to schedule some scripts (stored procedures) in the way that is described in this article - Run your ETL jobs with Azure Data Factory and Exasol (site.com). Basically, ADF sees Exasol as an ODBC connection.

 

I have managed to get everything connected and setup, however, am running into an error at the very final hurdle. I am able to setup a dataset in ADF, which allows me to to preview the data, so I am sure that the schema and table names are correct.

As per the Exasol tutorial, I need to use the lookup function in a pipeline to execute the script that I have created in the database. I have tested the that the script works, however when I try call the script from the lookup pipeline I get a range of errors which all seem to point the script in the script. I have tried to edit the script to include the standard Exasol syntax, with and without the schema. This is the error:

 

The following ODBC Query is not valid: EXECUTE SCRIPT "DW"."EXASOL_ADF_TESTING";

 

Does anyone have any suggestions as what I need to?

 

 

No RepliesBe the first to reply

Resources