Apache Ignite 2 with DBine
How to connect DBine to Apache Ignite 2 and what you can do once it's connected. This page is written from what the Apache Ignite 2 driver says about itself, so it matches the version of DBine you download.
Connect
- In DBine, open New connection.
- Pick Apache Ignite 2 in the list of engines.
- Fill in the fields below, press Test connection and then Save.
Default port: 10800.
General
| Field | Description |
|---|---|
| Server required | Example: localhost |
| Port | Example: 10800 |
| Schema | |
| User | |
| Password | Kept in the system keychain, never in DBine's files. |
| ODBC driver | ODBC driver name as shown in odbcinst.ini (“Apache Ignite”). On Windows it comes as an .msi installer with Ignite; on Linux libignite-odbc.so is built and registered with odbcinst. Default: Apache Ignite |
| Read-only | On or off. |
SSH tunnel. The connection can go through an SSH server, even through a chain of bastions, with a password, a private key or the SSH agent. The server's fingerprint is checked against known_hosts or confirmed the first time.
Advanced
| Field | Description |
|---|---|
| Additional attributes | They are appended to the end of the ODBC connection string and replace the ones with the same name (TLS, timeouts, character set, Kerberos or Windows integrated security…). Example: Key=Value;OtherKey=Value |
| Script sending | How a script is sent to the server. If the engine accepts several statements per request, “All text at once” keeps blocks such as BEGIN … END intact. Options: One statement at a time (separated by ;), Blocks separated by GO, All the text at once Default: One statement at a time (separated by ;) |
| ODBC library | Path to the ODBC driver manager (libodbc.2.dylib, libodbc.so.2 or odbc32.dll), only if it isn't found in the usual paths. A file on this computer. |
What the explorer shows
The objects appear right under the connection:
- Tables
- Views
Query editor
The editor uses SQL, with completion for the connection's objects. Statements and commands run against the database selected in the tab.
Ready-made templates for new objects:
- New view
Tools for Apache Ignite 2
Available
- Graphical execution plans
- Server monitor
- Manual transactions (commit and rollback)
- Index usage
- Visual designer for new objects
- Compare and sync schemas
- Native bulk load when migrating data
- Users and permissions
Not available for Apache Ignite 2
- Live query profiler
- Sessions and running queries
- End a session
- Locks: who blocks whom
- Cancel another session's query from the sessions list
- Create databases
- Drop databases
- Database properties
- Relations in the ER diagram
- Rename objects
- Clone tables
- Backups
Why a tool doesn't apply to an engine, and the details of each one, are in the engine support reference.
Generated from the Apache Ignite 2 driver 0.1.11, which DBine downloads the first time you connect to Apache Ignite 2.