ServiceNow Integration with Azure

M Ismail
Tera Guru

‎04-18-2024 03:11 PM

 
I have to Integrate ServiceNow with Azure to fetch the Asset data from Azure DataLake, I can't create a direct JDBC DataSource with Azure Data Lake and also can't install mid server on Azure network which is required for ServiceNow Principle Integration with Azure and I also can't create API's at Azure side.
@Dr Atul G- LNG , @Community Alums , @Ankur Bawiskar 
0 Helpfuls
  • 734 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎04-19-2024 03:05 AM

Hi @M Ismail 

Sorry mate, i have no idea here.

 

@AJ-TechTrek  @AshishKM any thoughts. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

AJ-TechTrek
Giga Sage
Giga Sage

‎04-22-2024 07:56 AM

Hi @M Ismail ,

 

Refer the below, Might help you.

 

To pull data from ServiceNow into Azure Data Lake using the REST API, you can follow these general steps:

  1. Authenticate with ServiceNow

  2. Construct API requests: For example, to retrieve all records from the "cmdb_ci_server" table, you can make a GET request to the following endpoint: https://instance.service-now.com/api/now/table/cmdb_ci_server.

  3. Handle pagination: ServiceNow API supports pagination through the "sysparm_limit" and "sysparm_offset" parameters.

  4. Extract and transform data: Once you receive the data from ServiceNow, you can process and transform it as per your requirements before storing it in Azure Data Lake. 

  5. Load data into Azure Data Lake

https://www.cdata.com/kb/tech/servicenow-sync-azuredatalake.rst

 

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

 

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

0 Helpfuls