I need help with Source Data

[Arthur Sanchez]

I managed to Create a Data Source with JDBC MySQL connection, I even read the data, but I want to somehow get it manipulated within servicenow, I want to be able to take the data that I was able to read and throw it elsewhere or even create tables importing this data, but I don't know how, I need help.

[AshishKM · Accepted solution]

Hi @Arthur Sanchez  , 

I believe you must have created a JDBC type Data Source and test connection also connected. 

Regarding data manipulation, you can create a transform map and attached to same Data Source, this transform map can be configure to map the stage table column(s) and target table com(s), you can also write some logic to change the data before inserting/or/updating on target tables.

Let me know if you need more details or help, try this on dev instance.

Open any Data Source, scroll down, there is Transforms on Related List.

-Thanks,
AshishKM

[Sumanth16 · Accepted solution]

HI @Arthur Sanchez  ,

You can use the transform maps in ServiceNow to perform some operations on data before storing it in to target table. For this, you need to create a Source(or) Import set table and you need to add this table to the data source that you use for connecting with other applications.

https://developer.servicenow.com/dev.do#!/learn/learning-plans/utah/new_to_servicenow/app_store_lear...

There are several types of transform scripts to do operations on data.

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[Arthur Sanchez]

I was able to take the data and throw it into the table inside the servicenow, but now I want when new data is inserted into the database the table will be updated as well. I did the same process using Transform, the problem is that it brings in all the data and throws it right into the table, and I want it to somehow only bring in new or updated data. How do I do that?