Alteryx connection to ServiceNow

Hello,

we are looking for a way to connect our SQL Database with ServiceNow via Alteryx. We want to regularly transfer tables into SQL. We have tested the ODBC connection, which is working but is very slow and not recommended by the ServiceNow team. Is there any experience out there with connecting ServiceNow via API or other methods?

Any ideas would be highly appreciated.

Thanks, Ulrich

Input

API

Accepted answers

joeGade

Service Now Connector is now available to download from Alteryx Public Gallery

Here is the Link. https://gallery.alteryx.com/#!app/Servicenow-Download/5e6731418a93370990b2a835

All comments

joshuaburkhow

Hi @ulrich_schumann

This has been addressed here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Service-Now-Connector/td-p/74330

However if you are interested in having us build it then feel free to message me!

Thanks

Joshua

ulrich_schumann

Hi Joshua,

thanks for your input. I'll might come back to you regarding a solution built by you.

For now we are going to have a closer look into www.snow-mirror.com. They offer a server based solution to export tables in various SQL databases. We'll see how that works ...

Thanks, Ulrich

joeGade

Service Now Connector is now available to download from Alteryx Public Gallery

Here is the Link. https://gallery.alteryx.com/#!app/Servicenow-Download/5e6731418a93370990b2a835

ulrich_schumann

Hi Joseph,

great, the updated version is working for me.

Thanks a lot!

Ulrich

BonusCup

@joeGade

This appears to be a download connector, do you know if there is an upload to SNOW?

TIA

jmpatino_jws

Great tool. Thank you for saving us the trouble. I have a question though. I tried doing a partial load where the Date Filter is hard-coded via a formula, and I encountered an error as seen in the pic below. Can you help?

Bonnieau

Downloaded servicenow connector, imported to alterys designer. But have following error when run the workflow to get the link

The job Servicenow Download did not complete successfully and resulted in the following errors:

Exception parse error line: 5 column: 3192 expected end of tag 'srcreport' (Tool Id: 😎

N_FirstMileAnalytics

Is there a way to get a table name from serviceNow connector in a column as a value?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335