JDBC Datasource queries

satmadye
Tera Contributor

Hi Experts,

 

We have a requirement to auto-create incidents in ServiceNow using JDBC Datasource.

 

Below SQL statement is shared by oracle db team.

SELECT * FROM audit_status_file WHERE BATCH_DATE = TO_CHAR(sysdate-1,'DD-MON-YYYY') and REJECT_COUNT > 0 order by exec_date desc; 

 

Use case 1: They want us to query only the delta records. I believe this can be achieved using Last run date time checkbox by entering exec_date in the Last run database field.

However, please confirm because I have read in one of the community posts that your sql query cannot have where or any condition if you are using the last run date time field. It should just be a select * from tableName

 

Use case 2: The Oracle DB Team doesn't wants this be a scheduled integration. They want ServiceNow to query DB & pull records on real-time basis so that incident creation happens quickly. 

Is that even achievable using JDBC Datasource ? 

 

 

0 REPLIES 0