1 / 6

Oracle To S3

Ready-to-use data delivered to Amazon S3, Amazon Redshift, and Snowflake at lightning speeds with BryteFlow data management tool. This automated tool is completely self-service, low on maintenance and requires no coding. It can integrate data from any API and legacy databases like SAP, Oracle, SQL Server, and MSQL.

michalSmitth84
Download Presentation

Oracle To S3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. An Overview of Migrating Oracle Database to Snowflake

  2. Since 1979 when Oracle database was first launched commercially, it has been the mainstay of data needs of organizations. The database enables quick storage and retrieval of data and runs on a wide range of hardware and software operating systems. Most applications can be easily integrated into the database and it was one of the first to support GNU/LINUX. Most critically, database security and data integrity is assured on Oracle as it is ACID-compliant. 

  3. However, the massive benefits offered by Snowflake have made most businesses today to migrate databases from Oracle to Snowflake. The latter is a recently-introduced data warehousing solution operating entirely in the cloud. It offers almost unlimited storage and computing capabilities. Users have the flexibility to scale up and down in data usage and pay only for the quantum of resources used. It is a high-performance solution too and multiple users can simultaneously work on multiple workloads and execute intricate complex queries without a drop in performance.   

  4. Migrating Database from Oracle to Snowflake There are four steps to migrate database from Oracle to Snowflake. Mining Data – The data has to be first extracted from the Oracle database to a CSV file by using the SQL Plus query tool. The “spool” command is used to complete this step. To mine all incremental data the SQL tool has to be run under specific conditions.  Processing the extracted data – The data that has been extracted from the database for migrating from Oracle to Snowflakehas to be processed and formatted now. The Snowflake architecture supports certain data types and the extracted data has to match one of them. However, there are certain character sets that need not be processed like ISO-8859-1 to 9, Big5, EUC-KR, UTF-8, UTF-16, and more. In the case of a character mismatch and for processing data, the File Format Option is used to insert dates and time to the table.

  5. Keeping data in a staging area – Even this processed and formatted data cannot be directly migrated from Oracle to Snowflakebut has to be stored in a temporary location called the staging area. There are two components here – an external staging area and an internal one. Snowflake is currently compatible with Microsoft Azure and Amazon S3 as external staging areas. For an internal location, users and tables are auto-directed to the internal stage that is assigned a name with the correct file and time format.  Copying files to Snowflake – This the final stage in the Oracle to Snowflakemigration process. When the size of the databases is limited, the Data Loading Overview tool of Snowflake is used. But for large databases, the PUT command is used in the previous step to load files to a staging area and then the COPY INTO command transfers the database from the temporary location to Snowflake   Migrating databases from Oracle to Snowflakeis not difficult with the right automated tools. 

More Related