Centerprise offers power and flexibility when it comes to extracting data from databases.
If you just need to clone a database onto another server, it's there with the "Database
Copy Batch" feature. If a selective query is necessary, Centerprise comes
shipped with a data model diagramming tool which can be used to help create visual
queries. In either case, extracting data from more than just a single table
can be effortlessly done in Centerprise.
Database Copy Batch
Database copy batches are, in essence, just transfer batches streamlined to make
copying multiple tables onto another database server as painlessly as possible.
You simply just click "New Database Copy Batch" button and, in a couple of clicks,
you can copy over all desired tables in a database over without having to go through
the usual steps of mapping. Think of it as a shortcut from having to explicitly
having to add a transfer (with mapping) for every single table you might have. If
you have hundreds of tables to copy, this becomes a lifesaver.
Click image to view a demo
Data Model
New in Centerprise is the ability to create visual database diagrams we call Data
Models. These Data Models are powerful visual representations of your database
and can be created easily. The drag-and-drop nature of these DataModels make
them an ideal alternative to the database browser when it comes to working with
your database data. These Data Models can be created by you and then passed
on to others who might not have as strong a familiarity with SQL. And besides
being a pretty face, these Data Models can actually be used as a source in a data
transfer and are an excellent way to perform a data extraction involving more than
just a single database table.
Click image to view a demo
Visual Queries
As an alternative to using straight SQL as a source for a data transfer, Centerprise
offers the ability to visually construct your query based around a predefined Data
Model. In this way, others, who may not be familiar enough with SQL to write
a complex query to get the data they're after, can use the Data Model to aid them.
Instead of writing complex joins by trial and error, you simply select related tables
in a tree and visually map fields as
if it were a single table. It couldn't
be easier.
Click image to view a demo