topic Re: Could you please guide us on connecting ServiceNow data in databricks in Data Engineering

Could you please guide us on connecting ServiceNow data in databricks

ankris — Mon, 29 May 2023 11:26:04 GMT

Would like to extract data like ticket info, resolve time, etc., from ServiceNow in databricks.

Not finding much information in community and appreciate your guidance on the same.

Re: Could you please guide us on connecting ServiceNow data in databricks

crannow — Wed, 07 Jun 2023 15:13:34 GMT

ServiceNow offers API capabilities. You can consume the ServiceNow API within a Databricks notebook to extract data from ServiceNow. Following is a suggested prompt to use with ChatGPT for example python code to connect to ServiceNow's api.

PROMPT: "As a Python and Databricks expert can you assist me in programming a connection to consume ServiceNow api's to get data like ticket information, and resolution time?"

Re: Could you please guide us on connecting ServiceNow data in databricks

Debayan — Tue, 30 May 2023 07:17:07 GMT

Hi, there are some third party JDBC connector on this (such as fivetran and cddata etc. ) , It seems like there is not enough documentation around JDBC connectivity from Databricks.