Projects tagged ‘db2’

The DBI module enables your Perl applications to access multiple database types transparently. You can connect to a large number of databases, including MySQL, MSSQL, Oracle, Informix, Sybase, ODBC etc. without having to know the different underlying interfaces of each. The API defined by DBI will work on all these database types and many more.

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Simple yet Powerful Jdbc Tool for browsing Relational databases. DBClient provides both a convenient SQL Editor (highlighting, auto-complete, ...) and automated Browsing and Refactoring Actions (Select, Drop, etc...). Since release 0.3, it is massively based on Plugins architecture which makes it very extensible.

ODBC Driver for perl DBI. Provides the Perl DBI::DBD interface to ODBC drivers allowing Perl access to any database which has an ODBC driver.

SchemaSpy is a Java-based tool 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 ... [More] 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. [Less]

LiquiBase is a DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control. ... [More] LiquiBase aims to provide a solution that: * Supports merging of changes from multiple developers * Works well with code branches * Allows you to manage production data as well as various test datasets * Works in an environment where multiple machines will be attempting to migrate the database concurrently * Supports automated change-applying or generation of SQL scripts that can be approved and applied by a DBA * Supports rolling back changes * Database "diff" tool [Less]

This is a MULTI-DB client. First, this software was intented to be a client just to DB2 Web-Based/Desktop client (general-purpouse), inspired on phpMyAdmin. But after the first release several users asked to add support to other databases, so since ... [More] version 0.0.9 the software have full support to DB2 (since version 8.1), MYSQL (since version 5.0), POSTGRESQL (since version 7.3), FIREBIRD (since version 1.5), DERBY (since version 10.1) AND ORACLE (since version 10g). The Desktop/SWING version runs on X,Windows,etc. The Web-Based version runs on Tomcat 5.5. All versions NEEDs JDK 1.5. [Less]

Model-based data export tool. Exports consistent, referentially intact row-sets from relational databases. Removes obsolete data without violating integrity. DBMS agnostic (JDBC). Generates hierarchically structured XML and topologically sorted SQL-DML.

XMLToaster is a two way database to XML mapping tool. It maps XML messages directly into database tables and extracts data into XML documents. It uses a simple SQL "select" like statement to extract data into XML documents of arbitrary ... [More] complexity. It scales to handle very complex mappings such as might be found when extracting from a legacy database into an ESB service catalog. Persistence is currently through an XML mapping file, shortly to be replaced by more user-friendly SQL style update statements. The persistence engine is also capable of handling enterprise level requirements. Key features: - Simple XML message generation from a database. - Quick and easy persistance of XML messages to the database without the traditional coding overhead. It specialises in handling very complex mappings of XML to tables. [Less]

benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or configuration files. Data can be imported from and ... [More] exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options. [Less]

A multiple choice exam system in Ruby on Rails and DB2

Use ruby to check db2 sql files. Make sure there are some grant statement in sql file. File name equal SP's name and so on.

This is a new intiative to develop a unique Dashboarding application. The development will be in PHP. The studio will allow to connect to any database and Excel files. It will allow you to create reports and Dashboards. Dashboard Studio will be able ... [More] to import dashboard definitions directly from InfoCaptor Designer. It will also have in-built role and security mechanism. This will be a totally new application from InfoCaptor which is a java based Dashboard application. [Less]

Dabo is a 3-tier, cross-platform desktop application development framework, written in Python atop the wxPython GUI toolkit. And while Dabo is designed to create database-centric apps, that is not a requirement. Lots of people are using Dabo for the GUI tools to create apps that have no need to connect to a database at all.