Building a Datawarehouse using Service Now

[callmatkarna]

Hello Friends,

I need to build a DWH to store all incidents which are raised and updates done on already raised incidents. And then export them to a csv file for DWH. In sys audit table i only see ID , Table , Load time . Old Value , New value.

Is there any way I can get full set of record , i.e. all fields of an Incident . Not only old value new value while exporting data from Table.

Please help urgently.

Maddy

[Community Alums]

Maddy,

What is your overall objective here? Just to have the data external to ServiceNow? Is it performance? If it is the latter, we have data archiving: http://wiki.servicenow.com/index.php?title=Archiving_Data.

I am still curious about the the answer here to get all the full data, but perhaps there is another solution to achieve your goal.

ben

[Inactive]

Maddy,

Crossfuze Solutions has a Data Extraction module that they sell. I have personally worked with this and have found it solid and very applicable. Here is an explanation of the Scheduled Data Extract Module offered by Crossfuze:

» Crossfuze Scheduled Data Extract

You can contact Crossfuze through the following link:

http://www.crossfuze.com/contact-us

On the form I am referring to the "Scheduled Data Extract"

[gflewis]

Hi Maddy.

Let me know if you are looking for something like this:

http://sourceforge.net/p/servicenowpump/wiki/Home/

Giles

[pavel_muller]

Maddy,

we have developed SnowMirror for exactly this purpose. It simply mirrors the data in ServiceNow tables into your own staging database. Then you can run ETLs to load the data into your DWH.

We have done several successful projects like that.

Please check out SnowMirror at http://www.snow-mirror.com/. It is similar to the pump mentioned above but it has been designed as an enterprise product. High performance, reliability, professional support, multiple database support, intuitive UI, etc, etc.

Pavel