DbSchema is an Apache Ignite designer featuring diagrams, schema migration and design in a team, schema deployment over multiple databases, SQL editor, data explorer, data generator, and more.
15 Days Free Trial. No registration. Purchase DbSchema
After connecting to the database, DbSchema will reverse engineer the Apache Ignite database structure and visualize it graphically. You will interact with the schema in layouts (diagrams). The graphical interaction will help to improve the database design. The layouts can handle large databases with more than 10.000 tables.
DbSchema model is using its own copy of schema structure, independent from the Apache Ignite database.
This is a separation between schema design and the database, with numerous advantages:
The Apache Ignite database can be managed directly over diagrams. You can add comments to Apache Ignite schema and generate interactive Apache Ignite
documentation.
Read More
An amazingly simple Apache Ignite data explorer and editor that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more.
The editor can explore data from multiple tables simultaneously using foreign keys or virtual foreign keys between tables.
If the schema is missing foreign keys you can create virtual foreign keys which will be part of the DbSchema model.
Read more
There is no need to be an Apache Ignite SQL pro to be able to write database queries.
Create queries is an easy task for the Visual Query Builder. The builder can use different Join types and Group By functions.
Read more
The Apache Ignite SQL Editor features syntax highlight, text auto-completion, query and script execution, Groovy support, graphical execution plan.
Read more
For development or test purposes you may need to fill the Apache Ignite database with randomly generated data.
A bunch of predefined reverse regular expressions as well numbers, date, JSON, and groovy script generators will help you.
Read more
DbSchema uses its own images of the schema, distinct from the Apache Ignite database, which is saved as a model file.
The DbSchema model can be compared with any database.
For each difference, you can decide to merge in the DbSchema model, apply it in the database, or generate the SQL scripts.
Read More
All major DbSchema processes, like schema synchronization and deployment, generate documentation,
reverse engineer schema structure can be automated using Groovy or JS scripts with direct access to DbSchema API.
Read More
Foreign keys are used for data accuracy.
If the database lacks foreign keys, you can create Virtual Foreign Keys that will be created only in the DbSchema model
and will be saved to the model file.
They will help you to gain a better understanding of the database.
Read More
You don't need a separate tool to build database forms or reports.
DbSchema can create responsive web reports which you can deploy on a separate server.
You may also create small applications with input fields, buttons, and charts.
Read More
Import data in the database from various files, including CSV, XLSX, XLS, XML, etc.
Read More
