Connect to phpMyAdmin to import tables from MySQL into ServiceNow

[JensHappeningIT]

Hi everyone,

I am trying to connect a table inside phpMyAdmin to ServiceNow. I have tried this with a JDBC Data Source but I got the error Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null. Can someone tell me how to fix this? Many thanks in advance!

[pratiksha5]

Did you find solution for it? I am getting the same error. 

[JensHappeningIT · Accepted solution]

Hello @pratiksha5 ,

No, turns out it was not needed for my project. The program that uses the database had a REST API on further research. So what I ended up using was a Rest Message of which I called its http method inside a custom (Load by script) data source with a MID server as the intermediary. 

This led me load my data as an import set. I don't know if this method can help you but good luck anyways.

Kind regards,

Jens

[pratiksha5]

Thanks, That we do when we build custom integrations. I am wondering why it is getting authenticated when the creds are right. 

[BLangley]

Hi, I'm getting the same message trying to connect SQLServer to ServiceNow for Import tables (Cannot invoke "java.util.Map.keySet()" because "this.fImportSourceFields" is null) after upgrading from Utah Patch 10 to Washington DC Patch 1. Prior to the upgrade this process was working in Utah.  Does anyone know how to fix this?