Azure Data Lake ServiceNow Data Connection Options

[jdeken]

Our team is looking for the best approach to pull cmdb data, including custom fields, out of ServiceNow into Azure Data Lake for reporting and analysis. When trying to pull data from using Azure it does not appear to want to pull the data that is in custom fields in ServiceNow. Would anyone be able to assist me in understanding how we could use Azure Data Lake and pull all data from ServiceNow? What would be the best approach to share the data to. Thanks so much!!!

[Arpit3]

Hello @jdeken : Were you able to get some insights on the same .. I am also looking for a solution to connect Azure data lake to ServiceNow . 

[jdeken]

I wish I had. I have not heard anything back. When we have tried, we have had issues with all the data coming over to Azure. Most of the time it is any custom attributes. Would love if anyone has done this successful to respond. Thanks for asking!

[jdeken]

Hello Friends. I wanted to follow up on this and see if anyone has a solution for this. It appears that Azure Data is not able to recognize all the columns/fields on a table in ServiceNow. We have some examples where it will recognize on certain tables but not others and both setup the same. 

Any assistance would be awesome here on how to allow for us to pull data up to Azure Data Lake. Thanks.

[amarparthas]

Not sure if you are still looking for an answer.
There are multiple ways to achieve this,

1) could use Snow Mirrow -- this could be more than what you need

2) Create Schedule Data Exports, assuming the Mid Server is running in Azure VM you Export Target will send to a path directly to Azure Data Lake Storage..

Good luck for anyone else looking for options.