Check the connection status of a datastore before processing

[former_member316405]

Hi Experts,
 
I've a requirement where I have to check the connection status of a datastore for a database before processing the dataflow.The source and target database is oracle.So I want to check it's status so if it's ok I can load the data into target otherwise wait till it's active.This is because my target databse goes down sometimes due to backup or maintenance.So Please share your thoughts how can I achieve this.
 
 
Many Thanks.

Niranjan

[Former Member · Accepted solution]

you can add a script before the Dataflow, and execute a dummy sql statement using SQL() function and do the error handling

sql('datastore name', 'SELECT sysdate FROM DUAL');

[former_member316405 · Accepted solution]

Yeah,I figured it out.Anyway Thanks for replying to my post.