• tomcoffing

Oracle to Amazon Redshift: Migrate, Federate, and Search



Are you considering migrating from Oracle to Amazon Redshift? Smart move! Converting the table structures and data types from Oracle to Redshift takes seconds with Nexus. Building the load scripts for each table takes the Nexus half a second.


Large Oracle systems can take time because many companies want to gradually migrate the data to Redshift. Another smart move!


So, customers also need to join data from Oracle and Redshift in a single query, which refers to a federated query.


The ability to search both systems simultaneously for specific columns helps manage both systems, especially when you can use the search to move or join data.


The video below shows you everything you need to migrate from Oracle to Amazon Redshift. By the way, you can also migrate 19 other systems to Redshift in the same way.





Today's users need a query tool that works brilliantly on all systems.

Today's users need to be able to join data across two systems seamlessly.

Today's users need to move data from one system to another in a point-and-click fashion with no technical knowledge required.

Today's users need to write the SQL or have the SQL built automatically. Today's users need search capabilities to look where a column resides in all their systems. Today's users need to take answer sets and join them with other answer sets, share them with peers, graph, chart them, pivot, and slice and dice them a hundred different analytics.

Today's users need to have dark mode when looking at their screen all day and be able to adjust the colors they see in the background completely.


All database vendors provide tools to access their systems, but none of them have any of the above features, so they are diminishing the power and purpose of their databases. In addition, the database vendors have never learned that the database and end-user access go hand in hand.


After writing 85 books on all database platforms and teaching over 1,000 classes worldwide for 20 years, I knew that software would one day overtake the importance of any single database.


I spent the last 20 years building the Nexus corporate software, which migrates one or thousands of tables across all database systems.


Last week I did a ten-table join across ten different systems using the Nexus Super Join Builder, and Nexus wrote the SQL automatically. I also searched on the column customer_number and found where it resides in 20 different systems, and I did it all in dark mode while joining and performing analytics on all answer sets I received that day.


Let the database vendors fight it out, but in the end, it is inevitable that everyone will access data across dozens, if not hundreds, of database platforms.


Here is the video of ten tables joining across ten database systems in a single query. Warning: This video contains what many experts thought was impossible.



Tom Coffing has also led a team of developers for almost 20 years to create the Nexus, which queries, migrates, and joins data across all systems. Amazingly, Nexus migrates between all the databases below with the click of the mouse.


• MySQL

• Excel

• Microsoft Access

• Snowflake

• Redshift

• Synapse

• BigQuery

• Teradata

• Oracle

• SQL Server

• DB2

• Hadoop

• MapR

• Greenplum

• Postgres

• Vertica

• Netezza

• SAP HANA

• Yellowbrick

• SQLite


It is never too early to dream about the future of data.





12 views0 comments