forked from RunningJon/outsourcer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
README.txt
executable file
·22 lines (21 loc) · 1.02 KB
/
README.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
README file for Outsourcer
***********************************************************************************
Site: http://www.PivotalGuru.com
Author: Jon Roberts
Email: [email protected]
***********************************************************************************
Outsourcer automates the tasks typically done manually by ETL developers to source
data from SQL Server and Oracle and load into Greenplum or HAWQ database.
* Connects to Source databases (SQL Server or Oracle)
* Converts Source DDL to Greenplum/HAWQ syntax and creates target schema and table
* Loads data into Greenplum/HAWQ automatically
* Supports multiple job types:
* Refresh (truncate and reload)
* Append (add only new data from source)
* Replication (tracks changes in the source and applies the changes)
* Transform (SQL commands to execute in Greenplum/HAWQ)
* Multi-threaded with dynamic number of jobs to execute concurrently
* Scheduler for recurring job execution
* Open Source!
* Automatic data cleansing
* Utilizes gpfdist for fast data loading