1 / 4

A Guide to Migrating Data from Oracle to Snowflake

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
Télécharger la présentation

A Guide to Migrating Data from Oracle to Snowflake

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. A Guide to Migrating Data from Oracle to Snowflake Oracle database solutions facilitate quick storage and retrieval of data and can be run on a wide range of hardware. Oracle database has been one of the first to have supported GNU/LINUX.  Snowflake is a comparatively recent cloud-based data warehousing solution, offered as a SaaS product. No new hardware or software has to be installed to run it. All tuning and maintenance issues are handled directly by Snowflake.

  2. There are several benefits of Snowflake that make enterprises want to migrate data Oracle to Snowflake. Users can work with both structured and unstructured data in Snowflake which is difficult in Oracle. Snowflake also offers separate storage and computing facilities and users can scale up and down in either of them, paying only for the resources used. Further, it provides great flexibility and elasticity and multiple workgroups can simultaneously work on complex multiple queries and workloads without experiencing any drop or lag in performance.

  3. The next step is to know how to migrate data Oracle to Snowflake Mining data from Oracle to Snowflake – Data is to be first extracted from Oracle through a SQL Plus query tool installed in the Oracle Database Server and the result is directed to a CSV file with the “Spool” command. However, SQL has to be run in specific conditions if incremental data, that is data after the last extraction has to be mined.  Preparing the extracted data – The data so extracted from Oracle has to be prepared and formatted before it can be loaded to Snowflake. It has to be checked if the data type in Oracle matches the types that are supported by the Snowflake architecture to avoid any data character mismatch. However, most major character sets like ISO-8859-1 to 9, Big5, EUC-KR, UTF-8, UTF-16, and more are supported by Snowflake. In other cases, a customized option has to be created with the “File Format Option” to insert time and dates to a file in the table. 

  4. Loading data to a Cloud Staging Area – The prepared and formatted data cannot be directly loaded to migrate data Oracle to Snowflake. It has to be kept in a staging area first. There are two aspects here. The first is an internal staging area that has to be created and a name assigned to it. Users and tables will be automatically allotted and file and date format are also auto-applied. The next is an external staging area. Here, Snowflake currently supports only Microsoft Azure and Amazon S3.  Copying Files to Snowflake table – This is the final step in the process to migrate data Oracle to Snowflake. For small databases, the Data Loading Overview guides users. For large ones, the PUT command is used to stage files and the COPY INTO table command to load processed data into an intended table.  Follow these steps to migrate data Oracle to Snowflake

More Related