Connect to phpMyAdmin to import tables from MySQL into ServiceNow

JensHappeningIT · ‎03-25-2024

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!

JensHappeningIT · ‎04-08-2024

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

View solution in original post

ofaura · ‎04-13-2024

Hello ,

I had the same issue, and solved updating the MySQL configuration; instead of using Strong Password option for authentication, I changed to "use legacy authentication method"

Now it works!

mattoedu · ‎04-12-2024

Change the listed format from "MySQL" to "MySQL - Non Maria".