Jobs
Overview Refreshing data in Greenplum is very simple with Outsourcer.
Outsourcer sources the DDL from the source database, converts it to Greenplum syntax, and then creates the target schema and table for you. Next, the data is loaded and the table is analyzed. Everything is automated for you!
You don’t have to convert DDL, extract files, clean-up bad data, transfer the files, create YML files, etc to get your data into Greenplum! Outsourcer does it all!
Overview Appending new data in Greenplum is very simple with Outsourcer.
Outsourcer takes the Refresh concept once step further by keeping tables up to date by identifying only the new data found in the source system to be inserted into Greenplum. This was designed with tables in mind that never have DELETE or UPDATE statements executed against it. A good example of this is a log table.
You don’t have to convert DDL, extract files, clean-up bad data, transfer the files, create YML files, etc to get your data into Greenplum! Outsourcer does it all!
Overview Replicating data to Greenplum is very simple with Outsourcer.
A challenge in many organizations is keeping a data warehouse or analytics platform up to date with Production data. Refreshing terabytes worth of data on a daily basis is time consuming and puts a huge burden on source systems.
Overview Transforming data in Greenplum is very simple with Outsourcer.
Outsourcer allows you to specify any valid SQL statement to be executed in Greenplum in a job. You can schedule these jobs just like loading data and you will be able to manage everything from Outsourcer.
Overview Do you need to convert the Oracle and/or SQL Server DDL to Greenplum syntax and then use gpfdist instead of Outsourcer to load the data? Outsourcer has the solution to just create the tables for you.
Outsourcer sources the DDL from the source database, converts it to Greenplum syntax, and then creates the target schema and table for you. That is it and it is fast!
Scheduling is including starting with Outsourcer 4.0!
Just define the schedule when to execute and let Outsourcer keep your data up to date in Greenplum.