One day you may run into a situation when you need to import data from a database which is not on the list of officially supported data sources for EasyMorph. Don’t give up too soon! If the database has an ODBC driver (64-bit), you may still be able to pull data from it, even if it’s not supported officially. Here is how you can do it:
Configure the ODBC driver, and make sure the connection works.
In EasyMorph create an ODBC connector and choose the “Generic SQL:2003” dialect.
In the Query Editor:
- Switch to the Custom SQL mode.
- Write a SELECT statement.
- Press “Run query” to see if it works.
- Press “Import to EasyMorph” to load the data into EasyMorph
In the screenshot above you can see a working query against a Google BigQuery table (which is not on the list of supported data sources). Feel free to write in the comments if you managed to successfully import data from other unsupported data bases using the method described above.