On-Premise or in the Cloud, the choice is yours...

Data warehouse and data conversion efforts have traditionally employed custom code or cumbersome tools to move and manage large amounts of database data. Relational Junction ETL Manager simplifies this process, minimizing the time and cost of data integration by using familiar and powerful SQL interface to all data sources. On-Premise or Private Cloud deployment eliminates any privacy concern.

With Relational Junction, you do not need extensive experience with the tool to be effective. Most developers are productive within minutes. Contrast this with other products, which require time-consuming and costly training for modest proficiency. Relational Junction can access many kinds of data, including relational databases, flat files, XML files, SaaS applications, Google, email, Excel, and many others.

Functionality

Uses simple SQL transforms instead of confusing proprietary scripting language

Allows any SQL construct, including table joins and unions

Offers smart insert / update using unique keys in target table

Does not constrain functionality with drag-and-drop interface limitations

Automatic timestamp filtering

Handles time zone changes between databases

Enables bolt-on business processing with database triggers and function

Ease of Use

Leverages existing in-house database skills

Intuitive web user interface

Short time-to-deploy with minimal training required

Developers are productive within minutes

Increases productivity — development time typically 2 tables per day, including data mapping, ETL setup, unit testing

Compatible with source control tools – all definitions stored as XML on the file system

High Performance

Multi-threaded database writers provide blazing performance

Typical ETL speeds are thousands of records per second

Low Total-Cost-of-Ownership

Hardware: 4-core 8GB RAM standalone server

Minimal training and support needed

Fault Tolerant

Captures and logs rejected records

Restarts at point of failure

Allows immediate termination at point of failure or bypass error and continue with error logging

Reports extensive load statistics

Additional Software Containers and Interfaces Available

The Oracle Java 1.8 client is a freely distributed product

The web interface requires a J2EE application server, such as the freely distributed Apache Tomcat.

JBoss and other J2EE web containers are also acceptable

JDBC Drivers are available for dozens of relational, API-based, and legacy data sources

 Simple, Intuitive Web User Interface

Java Cross Platform Support for all Major Operating Systems

Platform

  • Java provides complete cross-platform support for all UNIX 64-bit (Linux, Solaris, HP-UX, IBM, etc.) and Windows 64-bit platforms. Java is compiled once and will work on virtually all hardware platforms without the need for platform-specific modifications, meaning that all of our customers have the exact same distribution.
  • Java Database Connectivity (JDBC) is an application programming interface (API) for Java, that defines how a client may access a database. Relational Junction's JDBC interface with drivers from database and third party vendors is what gives it the ability to access on-premise relational databases, cloud databases, unstructured data, and API-driven applications.

On-Premise Relational Databases

Cloud, Big Data, and Document Data Sources

      In Beta:      

Azure

Application Data Sources

      In Beta:      

Find out how Relational Junction ETL Manager can help your business