- Makes native SQL operations more friendly thanks to its intuitive "point and click" interface.
- Loads data from virtually any data source: Microsoft SQL Server, Oracle, ODBC (level 3 compliance required), Access, Text Files, etc...
- Has a semi-guided process with meta data pre-populated fields, which helps reduce deployment time and common manual tasks.
- Allows all generated code to be accessed and edited.
- Has an administrative user interface to monitor and administer the progress of the data warehouse.
- Makes SQL Server Analysis Services OLAP Cubes accessible to all SQL database developers.
- Organizes data warehouse builds into a single visual process for your daily extract/transform routine.
- Doesn’t require interaction during the run-time process (automated run - runs in a "lights-out" fashion).
- Can schedule SSIS packages using the SQL Agent or your own enterprise scheduler.
- Requires no extensive designing or prototyping effort because data warehouses can easily be fine-tuned or expanded.
- Promotes teamwork and makes developer handover easier thanks to a standardized development process.
Click to find out more
or Call us on 0118 921 1555