architect

database exploration/builder written in Java

WWW CVSWeb GITHub
  1. Package version
    architect-1.0.6p9
  2. Maintainer
    Ian Darwin

The SQL*Power Group "Architect" is a powerful tool for understanding
and generating databases and offers some data mining facilities.
It has many "features geared specifically for data warehousing
including:

* Connect to any JDBC/ODBC-accessible source and target databases
* Compare the database structure of any two databases highlighting
the differences and generating a synchronize script
* Save a snapshot of all source systems data structures into the
project file allowing designers to work on the data model while
off-line
* Forward engineer many DBMS's including Oracle, SQL Server, DB2,
Postgres
* Forward engineer ETL templates containing source-to-target data
mappings
* Invoke ETL engine to load initial set of data into the target
database
* Enable easy, centralized installation and updates..."

+-----------------------------------------------------------------------
| Running ${PKGSTEM} on OpenBSD
+-----------------------------------------------------------------------

To get started with SQL Power*Architect, please see the
Getting Started wiki page at
http://software.sqlpower.ca/page/architect-demos

  • jdk->=1.8v0:devel/jdk/1.8