DataBata

DataBata is a tool for incremental database update based on HSQLDB SqlTool created for all types of workers: DBA, developers and QA. Currently Oracle and Postgres databases are supported. We plan to support all general RDBMSes.

For monitoring purposes there is DataBata Web Console.

What do you need to run DataBata?

• Java 6+
• Spring Framework
• Database driver
• HsqlDB sqltool (see databata-engine/lib folder)

Installation

Spring Framework: simply create following bean in your spring configuration

<bean id="propagator" class="eu.databata.engine.spring.PropagatorSpringInstance" init-method="init">
    <property name="jdbcTemplate" ref="jdbcTemplate" />
    <property name="transactionManager" ref="transactionManager" />
    <property name="changes" value="WEB-INF/db/changes" />
    <property name="packageDir" value="WEB-INF/db/packages" />
    <property name="viewDir" value="WEB-INF/db/views" />
    <property name="triggerDir" value="WEB-INF/db/triggers" />
    <property name="useTestData" value="false" />
    <property name="disableDbPropagation" value="false" />
    <property name="enableAutomaticTransformation" value="true" />
    <property name="moduleName" value="DATABATA_TEST" />
</bean>

NB! You need to reference jdbcTemplate and transactionManager beans in your configurations. And sql-files location is inside WEB-INF directory of your web application.

To run DataBata you need following dependencies in your classpath:

• gradle dependencies

  runtime 'commons-lang:commons-lang:2.4'
  runtime 'log4j:log4j:1.2.+'
  runtime 'org.springframework:org.springframework.jdbc:3.1.3.RELEASE'

  runtime 'com.oracle:ojdbc6:11.2.0.3'
  runtime 'org.hsqldb:hsqldb:2.2.9'
  runtime 'commons-logging:commons-logging:1.1.3'

• also include sqltool.jar and databata.jar from DataBata source.

Run examples in project

TODO instructions

Roadmap

• Core Engine
• Web Monitor