Kepler - SQL Query Fields | Grids & Dashboards
Query external databases and show retrieved data in Jira custom fields, tables, and dashboard grids.
Kepler TechnologiesPaid
Table Grid Next Generation
Add structured tables to Jira issues for tasks, orders, invoices, imports, formulas, and external data.
PRICINGPaid
DEPLOYMENTCloud · Data Center · Server
CATEGORYAdministrative tools
UPDATED ON MARKETPLACE
What it does
Adds configurable tables to Jira issues for structured data such as tasks, orders, invoices, quotes, and purchases. Tables can use columns for text, numbers, dates, checkboxes, dropdowns, and user lists, with formulas, filtering, and required columns. Data can be imported from Excel or CSV files, retrieved through JQL and external REST sources, or pulled from web services and databases. Multiple tables can be added to one issue, and the public API can retrieve grid data for visualizations and reports.
Key capabilities
from the Atlassian Marketplace listingConfigurable table columns
Tables support string, number, integer, dropdown, date, checkbox, and user-list columns.
Formulas and aggregation
Formulas can calculate and aggregate column values.
External data sources
Tables can retrieve data through JQL, external REST sources, web services, and MySQL, PostgreSQL, or Oracle databases.
Excel and CSV imports
Excel and CSV data can be imported directly into a grid.
Multiple issue tables
More than one table can be added to a Jira issue.
Grid data API
The public API can execute methods and retrieve selected grid data for visualizations and custom reports.
Use cases
- Tables can be used for project management and estimations.
- Orders, invoices, quotes, and internal purchases can be managed in tables.
- Data can be gathered from a support portal into grids.
How it compares
Table Grid Next Generation is paid and supports cloud, server, and data-center deployment. Kepler - SQL Query Fields | Grids & Dashboards is also paid with the same deployment options, while STAGIL Database Synchronizer is paid for data-center and server deployment. Power Custom Fields for Jira and Field Behaviours are freemium, and SIL Excel Connector is free for data-center deployment.
| Name | Pricing | Deployment | Updated |
|---|---|---|---|
| this plugin | Paid | Cloud · Data Center · Server | |
| Kepler - SQL Query Fields | Grids & Dashboards | Paid | Cloud · Data Center · Server | |
| STAGIL Database Synchronizer | Paid | Data Center · Server | |
| Power Custom Fields for Jira | Freemium | Cloud · Data Center · Server | |
| Field Behaviours | Freemium | Cloud | |
| SIL Excel Connector | Not in catalog | ||
In the catalog
1,002 plugins in Jira · Administrative tools
Price distribution: 271 free, 275 freemium, 456 paid
Pricing & deployment
Platform
Atlassian
Product
Jira
Deployment
Cloud · Data Center · Server
Pricing
Paid
More from Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, .
Similar plugins in Jira · Administrative tools
View all 1,002 →
STAGIL Database Synchronizer
Synchronize Jira issues and assets with data from SQL databases or CSV files.
STAGIL by catworkxPaid
Power Custom Fields for Jira
Configures dynamic, calculated, and linked custom fields in Jira using SQL databases or SIL scripts.
AppfireFreemium
Field Behaviours
Configure Jira fields, values, and choices based on projects, issue types, users, and changes in other fields.
WERAREFreemium
What the vendor says
«Some cool stuff our users are doing with TG ⚡️ Project Management & Estimations Order Management Creating Invoices & Managing Quotes Gathering Data from the Support Portal Managing Internal Purchases 💁TG is compatible with JSM! No need to create multiple custom fields to collect data from users, keep everything in …»
Official marketplace listing
Marketplace
Publisher
Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, .
Updated on marketplace
Facts verified