Re: MySQL Workbench, Connecting to Oracle DB

[Leonardo Quisbert Parra]

MySQL Workbench can only connect to MySQL servers. The conflicting info you found online is probably people confusing it with Oracle SQL Developer (which connects to Oracle) or third party tools that support multiple databases.

For what you actually need (getting data out of Oracle into MySQL), a few options depending on how often you need to do this. If its a one time thing, you can export from Oracle using SQL Developer or expdp into CSV files, then load them into MySQL with LOAD DATA INFILE or mysqlimport. Quick and dirty but works fine for a handful of tables. If the schemas are similar you could also use MySQL Shell's import utilities which handle CSV/TSV pretty well.

If you need to do this regularly or keep the data in sync, tools like Oracle GoldenGate, Stacksync, or AWS DMS can handle Oracle to MySQL replication without the manual export/import cycle. Depends on whether this is a one off migration or something you need running continuously.