Model-based Data Export Tool
Features
* Mass data export to XML and SQL.
* Generates hierarchically structured XML and topologically sorted SQL-...Model-based Data Export Tool
Features
* Mass data export to XML and SQL.
* Generates hierarchically structured XML and topologically sorted SQL-DML.
* Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment.
* Removes and archives obsolete data from your productive database without violating integrity.
* Open Source. Entirely written in Java. Platform independent. DBMS agnostic.
to tools software develop sql java mdd mda xml database by gresch on Jun 28, 2008, 9:06 PMData Architects, DBA's, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use...Data Architects, DBA's, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use of their resources. The Power*Architect allows these busy highly technical resources to perform this most intricate part of their job in a fraction of the time.
The Power*Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.
Plus, the Power*Architect has the ability to take snapshots of database structures, allowing users to design DW data models while working offline.
Whether you are building a Data Warehouse or using data models to communicate business rules, the Power*Architect will facilitate and automate your data modeling efforts.
to database design dba software erd sql develop modelling by gresch on Mar 28, 2008, 10:41 PMThe XAware project provides real time data integration with a service-oriented flavor. XAware makes other tools and frameworks much more productive by hidi...The XAware project provides real time data integration with a service-oriented flavor. XAware makes other tools and frameworks much more productive by hiding data complexity behind "XML views". XML views span any number of data sources, and can read data, write data, or transfer data between sets of sources, all within a distributed transaction.
to frameworks eai springframework database software transformation transactions soa eclipse xml java_ee uml develop integration sql by gresch on Feb 11, 2008, 2:35 PMTopMind Systems, jLynx Persistence Framework, simplified java persistence, code generator, JPA, Hibernate, TopLink, iBatis, SQL Server, Oracle, MySQL, JDBC jLynx is a simple, lite, hi-performance layer over the JDBC API. Persist and retrieve POJO and Map objects directly. Designed for developer productivity. S...jLynx is a simple, lite, hi-performance layer over the JDBC API. Persist and retrieve POJO and Map objects directly. Designed for developer productivity. Simpler, easy to learn, easy to configure as compared to Hibernate, JPA, etc.
jLynx generates JavaBean objects based on your database schema. For example if you have 24 tables and views in your database, jLynx will create 24 objects with properties that map to the field names in each table. The jLynx Generator creates the objects and compiles them. You can also use the generated source instead if you prefer to customize the objects. Using the API to persist objects is trivial.
jLynx Framework implements the Relational interface, which has all necessary methods to persist objects and fetch entire collections of objects.
jLynx leverages the strengths of SQL and the strengths of Java without having to write/maintain J2EE code. It is truly the best of both worlds.
to framework develop persistence software server jdbc java sql db by gresch on Oct 30, 2007, 5:59 PMlog4jdbc is a JDBC driver that can log SQL and/or JDBC calls (and optionally SQL timing information) for other jdbc drivers using the Simple Logging Facade...log4jdbc is a JDBC driver that can log SQL and/or JDBC calls (and optionally SQL timing information) for other jdbc drivers using the Simple Logging Facade For Java (SLF4J) logging system.
to db database develop java sql tracing tools software frameworks logging by gresch on Oct 30, 2007, 5:44 PMSQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and thus it should run on any operating system that provi...SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and thus it should run on any operating system that provides a Java Runtime Environment.
It's main focus is on running SQL scripts (either interactively or as a batch), graphical query building or administration of the database is not the focus.
to software java sql db tools develop database admin by gresch on Oct 23, 2007, 7:57 PMDo you hate starting on a new project and having to try to figure out someone else's idea of a database? Or are you in QA and the developers expect you to ...Do you hate starting on a new project and having to try to figure out someone else's idea of a database? Or are you in QA and the developers expect you to understand all the relationships in their schema? If so then this tool's for you.
SchemaSpy is a Java-based tool (requires Java 1.4 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
to tool erd software schema database sql db develop tools reverse-engineering by gresch and 3 other people on Oct 22, 2007, 8:32 AMQuantumDB is a simple but powerful database access plug-in for the Eclipse Development Platform. QuantumDB allows you to:
* connect to databases usi...QuantumDB is a simple but powerful database access plug-in for the Eclipse Development Platform. QuantumDB allows you to:
* connect to databases using standard JDBC drivers
* review schemas, tables, views and sequences
* look up column, index and foreign key information
* issue ad-hoc queries or other SQL statements against the database
* manage, edit, and work with SQL files (*.sql)
* issue updates, deletes, and inserts using simple, easy-to-use wizards
to java db sql plugins develop software plugin eclipse by gresch and 1 other person on Aug 25, 2007, 11:36 AMEclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionali...Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases.
to java_ee eclipse software tools sql plugins jdbc develop db computing by gresch on Aug 20, 2007, 11:45 AMERD Modelling tool ODBC/Windows, not bad
to modelling develop db oracle sql tools mysql erd design by gresch and 1 other person on Jul 5, 2007, 1:27 PMThe Sundog Database Refactoring Tool (SDRT) is an open source (LGPL), DBMS-independent library that eases database development, particularly in an agile en...The Sundog Database Refactoring Tool (SDRT) is an open source (LGPL), DBMS-independent library that eases database development, particularly in an agile environment.
to sql computing db tools refactoring develop database by gresch on Apr 16, 2007, 1:20 PMMy thoughts on evolutionary design in regards to databases. Database administration. Best Pratices, Database utilities and other things
to db agile sql computing information dba reference develop blogs by gresch on Apr 13, 2007, 6:06 PMMIGRATEdb will parse an XML file of database changes and load them to the targeted database if they are not already there.
A database change consists of...MIGRATEdb will parse an XML file of database changes and load them to the targeted database if they are not already there.
A database change consists of tests to determine whether the change has already been applied and a set of change actions.
to refactor db tools sql develop computing database by gresch on Apr 13, 2007, 6:05 PMdbdeploy is a Database Change Management tool. It helps developers and
DBAs change their database in a simple, controlled, flexible and
frequent manner
to java db computing sql refactor tools software database ant develop by gresch on Apr 13, 2007, 5:46 PMAs an FAQ you can easily navigate to the sections of interest. It is recommended to start with the NLS_LANG Parameter Fundamentals section first to get a b...As an FAQ you can easily navigate to the sections of interest. It is recommended to start with the NLS_LANG Parameter Fundamentals section first to get a basic understanding of how the NLS_LANG parameter works.
to i18n develop sql computing oracle software by gresch on Mar 5, 2007, 12:32 PMSuperQuaiL is a Java SQL query builder. The goal of SuperQuaiL is to help Java developers who code SQL run and create queries easier. Other database tools ...SuperQuaiL is a Java SQL query builder. The goal of SuperQuaiL is to help Java developers who code SQL run and create queries easier. Other database tools focus on making it easy to do database administration and it is nice to be able to inspect the database through these tools. PhpMyAdmin, for example, a is nice web front end that you can run from multiple computers, but the interface is clumsy for the developer. For development, building queries is the main task and having a small program that loads quickly is more helpful than having a complicated interface where you can find out almost anything about the database. SuperQuaiL provides nice features to aid in the process of developing queries quick and easy.
to database tools sql software db develop java by gresch on Feb 15, 2007, 11:30 AMTalend has the most open and powerful data management solutions available as a packaged, out-of-box, ready-to-install platform.
Talend's fundamental techn...Talend has the most open and powerful data management solutions available as a packaged, out-of-box, ready-to-install platform.
Talend's fundamental technology breaks with the market's leading proprietary solutions, associated with the open source model, significantly modifying the rules of the game in the data integration market.
to data db etl tools programming computing sql develop by gresch on Jan 25, 2007, 8:53 AMThe goal is to create an eclipse plugin to design and edit entity relationship diagrams. On the other side, the plugin should also be able to create SQL an...The goal is to create an eclipse plugin to design and edit entity relationship diagrams. On the other side, the plugin should also be able to create SQL and Java-Code (Hibernate) out of the diagrams.
to sql develop java db eclipse tools erd by gresch on Dec 20, 2006, 5:56 PMDB2 Survival Guide DB2 Environment Basics - Rudimentary information.
to sql database db2 develop howto by gresch on Aug 28, 2006, 9:28 AMXML to DDL is a set of python programs to convert an XML representation of a schema into a database and vice versa. It can also examine the differences bet...XML to DDL is a set of python programs to convert an XML representation of a schema into a database and vice versa. It can also examine the differences between two databases and emit the ALTER DDL statements required to bring the database up-to-date. This
to xml tools ddl db develop oracle programming schema database sql by gresch on Aug 14, 2006, 6:12 PM
