Integrate PHP, MySQL website with Servicenow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2016 01:24 AM
Can we integrate our PHP, AJAX, MySQL website with Servicenow so that changes made to our MySQL database can enter data automatically into the Servicenow database?
After reading some of the impressive amounts of developer information here I would assume that the answer is 'yes' and that it will be quite easy but I just want to make sure.
Our customer is a large company using Servicenow who want changes made on our website to appear in their Servicenow application. But we want an easy life and need to achieve this without too much customisation which may impact other customers who use our system. We also need it to 'just work' once it's setup, without daily oversight or maintenance.
Is this possible? Thanks!
- Labels:
-
Integrations
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2016 01:45 AM
The easiest method of integration is going to be via web services, either SOAP or REST.
SOAP Web Service - ServiceNow Wiki
If you're unsure about the data coming in, or it needs manipulation, work with an import table and use a transform script to populate the ServiceNow tables.
Import Set API - ServiceNow Wiki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2016 05:49 AM
Sorry, we don't have any experience of either REST or SOAP I'm afraid, although we could learn I suppose.
Are there any other ways of doing this? For example via some middleware running on our server using ADO talking through an appropriate ODBC driver or something? All data would be validated prior to sending.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2016 05:54 AM
Hi Ross,
You could use MID Server to talk to your mySQL database, it'll enable you to run imports of data into ServiceNow and then transform data as described in the link Ian posted above
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2016 06:24 AM
I'll have a look at that then. I found the MID Server wiki here and I'll have a read through it.
Meanwhile, I've discovered that SOAP isn't so scary really and may try and use that too.
I will probably be back here with some more completely noob type questions soon though. Thanks for your responses so far though guys. This is a very new world for us and we may take a little while to understand how it all works. Bear with us!
