Importing Change Requests from Service Now

[Anonymous user]

Hi,

I am trying to import change requests from ServiceNow into the DCO system and store it in the CHANGE_TICKET table in DCO. Based on the information I found I need to create an ETL transformation using the Pentaho Kettle tool. My question is, what exactly does the Kettle transformation do? Does it have to write/ Insert the data into the DCO database directly, or should it do something else?

Thank you!

[Valentin_Kozlov · Accepted solution]

Hi Dasith!

Basically transformations need to manipulate data the way you want.

You can get excel file, take some data from it and process it before storing in database (make some calculations, validating, etc) for example. You can define what exact column in your file will be stored in particular field and tables of the ETL database.

You also can prepare all data outside of DCO and load it in database directly via jdbc.

In this case you should choose "No transformation" option in ETL database settings.

[Anonymous user]

Hi Valentin,

I have one more question related to this. So if I write data to the "Staging Database" created by "Manage ETL Configuration" will DCO automatically pull it to the DB of the application? Or do I need to write the data directly into the DCO DB?

Thank you!

[Valentin_Kozlov]

DCO DB is closed against external access, you should use staging database.

When you create staging database you should select "No Transformation" option on transformation page and configure synchronization schedule. 

Then data from staging DB will be synched to DCO DB according schedule automatically.