DZone
Integration Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Integration Zone > Using the GridGain Web Console for Automatic RDBMS Integration With Apache Ignite

Using the GridGain Web Console for Automatic RDBMS Integration With Apache Ignite

Apache Ignite helps support applications that heavily rely on relational databases for data persistence purposes.

Prachi Garg user avatar by
Prachi Garg
·
Dec. 19, 16 · Integration Zone · Tutorial
Like (6)
Save
Tweet
5.80K Views

Join the DZone community and get the full member experience.

Join For Free

While most applications use distributed in-memory caching for fast data access, they heavily rely on relational databases for data persistence purposes. For such applications, Apache Ignite supports read-through and write-through modes to read and write the data to and from the underlying persistent store, respectively. Moreover, Ignite can import database schemas and automatically generate all the required XML OR-mapping configurations and Java domain model POJOs that you can easily download and copy into your Apache Ignite project.

Automatic RDBMS Support in Apache Ignite

Apache Ignite supports automatic RDBMS integration via the GridGain Web Console which is an interactive configuration wizard, as well as cluster management and monitoring tool that allows you to:

Create and Download Various Configurations for Your Apache Ignite Cluster

The Web Console takes you through a detailed, step-by-step process to define all the required configuration parameters for your Apache Ignite cluster. It then generates a Maven-based ready-to-use project with all the configuration files in XML and Java.

Creating cluster configuration using the Web Console

Automatically Import Database Schemas From Any RDBMS

The GridGain Web Console can save developers from hours of manual coding by automatically importing the database schema, and generating XML OR-mapping configurations and POJOs that can be downloaded and copied into an Apache Ignite project.

The Web Console can integrate with any RDBMS that supports the JDBC driver - Oracle, PostgreSQL, Microsoft SQL Server, MySQL, and more.

Importing database schema using the Web Console

Execute SQL Queries Over Your In-Memory Caches

After starting the Apache Ignite cluster using the configurations downloaded from the Web Console, you can connect your cluster with the web console and run SQL queries over the cached data. You can also view query execution plans, in-memory schema, and real-time streaming charts for your cluster.

Note that you can also connect the Web Console to an already existing Apache Ignite cluster. Refer to the web agent documentation on how this can be done.

Running SQL queries on cached data using the Web Console

Conclusion

Apache Ignite's automatic integration with virtually any RDBMS via the GridGain Web Console is a convenient feature to automatically import database schemas and generate all the required XML OR-mappings and Java object classes. It also speeds up the creation of configuration files for your Apache Ignite project by allowing you to define all the necessary parameters in a multi-step process and automatically generating the configuration files in XML and Java.

Apache Ignite Console (video game CLI) Database Integration cluster Relational database

Published at DZone with permission of Prachi Garg. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Common Types Of Network Security Vulnerabilities In 2022
  • SQL CTE: How to Master It in One Sitting With Easy Examples
  • Secure Your WSO2 Micro Integrator Deployment
  • How BDD Works Well With EDA

Comments

Integration Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo