WowMaker | Free Data Migration & Export Tool for Snowflake

This utility is not intended to run on the DB server itself so please install it on a stand-alone machine that has connectivity to all your sources.

Windows export utility to automatically transfer entire set of tables & data from following database platforms to Snowflake.

Below are the Supported Sources:

• Microsoft SQL - (Requires Microsot SQL OLEDB 64-bit Driver here)

• Oracle - (Requires Oracle OLEDB 64-bit Driver found here)

• RedShift - (Requires RedShift ODBC Driver found here)

• SAP Hana - (Requires Hana ODBC Client found here)

• MySQL

• Postgres - (Requires PostGre ODBC Driver found here)
  
  

Installation

App requires Snowflake_ODBC_driver Win64 to be installed on the machine before it can run properly.

1- Download WowInstaller.msi

2- Run the WowInstaller.msi file (You may have to click INFO & RUN ANYWAY if you get DON'T RUN warning due to this app not being signed)

3- Download & Install Snowflake Win64 ODBC Driver

4- Download & Install drivers matching your Source Databases

• Download Microsot SQL OLEDB 64-bit Driver
• Download Oracle OLEDB 64-bit Driver)
• Download SAP Hana ODBC Driver
• Download PostGres ODBC Driver
• Download RedShift ODBC 64-bit Driver

5- Search & Start Wowmaker Migration to Snowflake in your Programs Menu (OR Run ""C:\Program Files\Wowmaker\WowMaker SQL_to_Snowflake\WowMaker_SQL_2_Snowflake.exe")

Description

This utility will automatically move tables (in full) from a source database (MsSQL or Oracle) to Snowflake. Just select a list of tables from source db and point to an existing Snowflake account & a database with proper user cridentials to start transfering schemas, tables & data.

The tool will do the following for each table:

• Generate a DDL & Create the table in Snowflake.
• Auto map proper datatypes.
• Perform date type conversion
• Login to Snowflake using SSO. Fill in userid in WowMaker & Leave PW blank. Userid has to match the userid used with SSO.
• if EXPORT DATA is checked (checked by default)
  • Export the data into a temp folder as flat files broken in to chunks (10MB - 600MB).
  • Create an internal stage in the target Snowflake database & Upload the files
  • Copy the uploaded files into the proper table in snowflake.

This product is a personal project & provided as is without any warranty. This application is not associated with Snowflake Inc. & not a supported product. Please use it at your own risk.

Version History

• 5/11/2022 Added SSO login for Snowflake. Enter only username & leave PW blank in Wowmaker UI

• 6/23/2021 Added Redshift as a separate Source using RedShift ODBC Drivers

• 2/9/2021 Added SAP/Hana as Source

• 3/11/2021 - Removed Clientside 45 secs Timeout

• 12/20/2020 Added PostGres as Source

• 12/18/2020 Added Proxy Server option for Snowflake

• 12/02/2020 - Fixed date formatting issues

• 11/30/2020 - Updated V9 - Added MySQL Schema & Data Export option (beta)

• 11/23/2020 - Updated V8 - Added ORACLE Schema & Data Export option (beta)

  • Extraction Performance improvements for larger datasets.
  • Modified RECORD_SEPERATOR to HEX 0x02 to reduce export file size.

• 11/22/2020 - Updated V7 with following changes

  • Extraction Performance improvements for larger datasets.

• 11/21/2020 - Updated V6 with following changes

  • Added Windows Authentication support for SQL connection
  • Added max file size option for exporting chucks for large table exports (10, 25, 50, 75 & 100 MB)
  • Added Option to Enable/Disable client side file compression (gzip) prior to uploading to Snowflake
  • Enhanced logic to reduce redundant SQL create schema commands.
  • Fixed an issue with Column names with spaces.
  • Fixed an issue displaying status for tables with 0 records

<BR><BR>

Export Microsoft SQL

Export Oracle

Export MySQL

Export Postgres