Using data source as a real time integration

[shill]

I have a system that I am pulling data into Service-Now from using a JDBC data source.
I am planning on having a scheduled import of this data, but now they are requesting the query to be on demand.

I guess what I am trying to do is use a UI action to format the SQL query so that it includes a users employee number, trigger the data source import with that formatted query, and return only those records that involve the employee.
I know I can trigger the import by script, but I don't want to force the user to wait for the whole table to import and transform as they are only interested in one users record.

Would this be possible?

[jason_petty]

I did something similar for a customer that you could probably use at least part of it:

http://community.servicenow.com/blog/jasonpetty/updated-use-email-attachment-create-data-source-load-data-and-run-transform

[sivaranjaniduvv]

HI Steve,

Were you able to get this done? I have a similar requirement to get the data from external DB and show it in real time.

Help will be appreciated.

Thanks

[shill]

This was something I was working on at a previous employer, so honestly, I don't remember if I was able to complete or I went in a different direction.

I do know I did something similar at my current employer with an LDAP import where I dynamically changed the LDAP filter on the OU definition so as to pull only those users I needed to update that I gathered in a script.

Are you needing a dynamic SQL query, or do you just need to trigger the import via a UI action (or something similar)?