Contributed by Calpont, InfiniDB Community Edition is an open source, scale-up analytics database engine for your data warehousing, business intelligence and read-intensive application needs. Enabled via MySQLTM and purpose-built for an analytical workload with column-oriented technology at its core, the multi-threaded capabilities of InfiniDB Community Edition fully encompass query, transactional support and bulk load operations.  So come on in, grab a download and get started.

             | 

How Can I Move Data from Oracle to InfiniDB?

E-mail Print PDF

There are a number of ways to move data from Oracle to InfiniDB. Any data movement tool that can connect to MySQL is a candidate for moving data to InfiniDB. For example, a DBA can freely download and use an open source ETL tool such as Talend or Kettle from Pentaho to move data and do transformations if needed. 
Oracle does not supply an unload tool for its database, so unless they possess a third party unload tool to unload Oracle data, then a DBA is oftentimes reduced to spooling a flat file out from a SQL*Plus session. For example, if a DBA wanted to create a flat file from Oracle to load into InfiniDB that contained a table named ‘workorder’ with three columns, and delimit the data with the pipe (‘|’) character, they might use a script such as the following:

Oracle Data Transfer