4
12
Customers have installed this app in at least 12 active instances.

    Reporting Connector for SQL Databases

    by M20 Technology LLCfor Confluence Server 6.1.0 - 7.6.2 and more versions
    Versions available for Confluence Server 5.5 - 6.0.7
    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Supported
    M20 Technology LLC supports this app.

    Get support

    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Combine the power of the Reporting add-on with your existing databases

    Combine the power of the Reporting add-on with your existing databases

    Combine the power of the Reporting add-on with your existing databases

    Enterprise Reporting

    Knowledge in Context

    Same Report Structure

    Combine your organization's existing databases with the power of the Reporting add-on to build sophisticated reports.

    Build knowledge portals supplementing your database data with wiki data

    No need to learn new macros. If you're already familiar with the Reporting add-on, just start using the new suppliers!

    More details

    This app extends ServiceRocket's Reporting add-on to integrate data from proprietary SQL databases. Combine your database data with your Confluence data to build powerful knowledge portals and sophisticated reports.

    This add-on requires Reporting 6.0 or later

    Please watch our demo videos to explore some solutions:

    Reviews for cloud

    (4)
    Sign in to write a review
    by Heiko Burghardt on 2016-07-14
    The Scaffolding plugin is essential to store structured data in Confluence manually. This data can be used to generate powerful reports on this data from different views using the reporting plugin. In the beginning for example we only had a static page (an inventory table) to list the specification of our IT systems. The page was growing and growing until it was almost unusable. It took a lot of seconds to load and was crammed with required information for many purposes. Scaffolding and Reporting improved the situation a lot by creating simple reports for different purposes. But in our IT organization with a lot of automated processes documentation also needs to be automated as much as possible. The Reporting Connector for SQL Databases integrates into the Reporting plugin. It helps to combine the more or less static information (e.g. about a system support contracts) stored by Scaffolding with automatically generated information by scripts (like software versions) stored in an SQL database. There is simply an attribute as keyword required in both stores to join the data to a report, in our case mentioned above it is the fully qualified hostname. The Reporting Connector for SQL Databases (in conjunction with Scaffolding and Reporting) gives us the flexibility to present our collected data on the current state in all views basically as we need it. A great plugin we had been looking for quite long! Thanks to Michael and M20 Technology for the assistance and for letting us participate during the beta phase!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Reviews for server

    (4)
    Sign in to write a review
    by Moritz Wagner on 2019-12-12
    Very good for basic SQL functionality. Sadly nested queries are only possible without variable injection. Support is effectively not present, as all support requests I had in the past were simply ignored. Nevertheless useful.
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    M20 Technology LLC

    Hi Moritz,

    I would like to express my sincerest apology for the unresponsive support. We've identified the factors which led to this issue and have made additional adjustments to ensure this not happening again in the future. Thank you for bringing this to our attention.

    We have reviewed our support queue and all of your open requests have been responded to or resolved.

    We're currently investigating capabilities regarding nested queries without a variable injection, and would love to discuss your use case further. I would also like to mention that we offer hands-on support, including 1-on-1 video consultations for all customers who purchase the app.

    Please feel welcome to reach out at anytime regarding any of the above.

    Kind Regards,

    Kerrod Williams, M20 Technology

    kerrod@m20tech.com

    by Ted Mahsun on 2018-04-16
    This truly is a wonderful product. The Reporting Connector for SQL Databases extends ServiceRocket’s Reporting add-on and allows it to to integrate data from various SQL databases with your own Confluence data. This allows for sophisticated reports to be built right within a Confluence page and ServiceRocket's customers love this powerful ability to extend Reporting.
    Was this review helpful?YesNo
    by Business Systems Administration on 2018-03-15
    Samaritans uses this product on our Intranet. Our Intranet is used by 20,000 providing an invaluable service to the general public. We have been using Confluence for a number of years and this add on is key functionality which is embedded into and integral to our pages. Thank you for enabling us to use this! Business Systems Manager, Samaritans
    Was this review helpful?YesNo
    by Heiko Burghardt on 2016-07-14
    The Scaffolding plugin is essential to store structured data in Confluence manually. This data can be used to generate powerful reports on this data from different views using the reporting plugin. In the beginning for example we only had a static page (an inventory table) to list the specification of our IT systems. The page was growing and growing until it was almost unusable. It took a lot of seconds to load and was crammed with required information for many purposes. Scaffolding and Reporting improved the situation a lot by creating simple reports for different purposes. But in our IT organization with a lot of automated processes documentation also needs to be automated as much as possible. The Reporting Connector for SQL Databases integrates into the Reporting plugin. It helps to combine the more or less static information (e.g. about a system support contracts) stored by Scaffolding with automatically generated information by scripts (like software versions) stored in an SQL database. There is simply an attribute as keyword required in both stores to join the data to a report, in our case mentioned above it is the fully qualified hostname. The Reporting Connector for SQL Databases (in conjunction with Scaffolding and Reporting) gives us the flexibility to present our collected data on the current state in all views basically as we need it. A great plugin we had been looking for quite long! Thanks to Michael and M20 Technology for the assistance and for letting us participate during the beta phase!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Reviews for Data Center

    (4)
    Sign in to write a review
    by Heiko Burghardt on 2016-07-14
    The Scaffolding plugin is essential to store structured data in Confluence manually. This data can be used to generate powerful reports on this data from different views using the reporting plugin. In the beginning for example we only had a static page (an inventory table) to list the specification of our IT systems. The page was growing and growing until it was almost unusable. It took a lot of seconds to load and was crammed with required information for many purposes. Scaffolding and Reporting improved the situation a lot by creating simple reports for different purposes. But in our IT organization with a lot of automated processes documentation also needs to be automated as much as possible. The Reporting Connector for SQL Databases integrates into the Reporting plugin. It helps to combine the more or less static information (e.g. about a system support contracts) stored by Scaffolding with automatically generated information by scripts (like software versions) stored in an SQL database. There is simply an attribute as keyword required in both stores to join the data to a report, in our case mentioned above it is the fully qualified hostname. The Reporting Connector for SQL Databases (in conjunction with Scaffolding and Reporting) gives us the flexibility to present our collected data on the current state in all views basically as we need it. A great plugin we had been looking for quite long! Thanks to Michael and M20 Technology for the assistance and for letting us participate during the beta phase!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    10 users$1025 users$12050 users$220100 users$400250 users$800500 & upAdditional pricing details

    Pricing FAQ

    How does server app pricing work?

    Server products and apps are hosted on your servers. This app is sold as a perpetual license, and the purchase price includes 12 months of maintenance (support and version updates).

    You can renew maintenance after 12 months at 50% of the current purchase price. You can upgrade the tier of your Atlassian product and app licenses at any time. Upgrade prices are calculated based on Atlassian's formula (view example).

    If app pricing changes after your initial purchase, there's a 60-day grandfathering period during which you can renew based on the old pricing.

    How do I determine my server pricing?

    Apps are billed based on the number of users in your Atlassian product. The app tier should match the licensed user tier of the Atlassian product. For example, if you have a Confluence license for 500 users, you should purchase the 500-user tier for apps. Even if fewer users want to use the app than your Atlassian product license, the two licenses should match exactly.

    Can I install this app in a Data Center product?

    This app does not have a Data Center approved version. Only apps meeting a set of performance requirements for large, clustered environments are approved for Data Center.

    However, while server apps are built for single-server deployments, many customers successfully install them in Data Center products. If you're using a Data Center product, Atlassian recommends you contact the vendor to determine compatibility at scale.

    Learn more about Data Center approved apps

    What type of license do I need if I'm using this app in a Data Center product?

    Because this app does not have a Data Center approved version, you should purchase a Server license if you decide to install this app in a Data Center product.

    Learn more about Data Center licensing

    Do you offer academic, community, or open-source licenses for server apps?

    For server apps, academic licenses are available at a 50% discount if you have an academic license for your Atlassian product.

    Community and open-source licenses are available for server apps. Learn more about community and open source licenses.

    Can I extend my free trial?

    For server apps, you can extend your app trial up to 5 times - in other words, for up to six months. Extend your trial by generating a new evaluation license key from Atlassian Marketplace. Click Try it free and you'll be directed to generate a new license. Paste this license key into the app listing in UPM from your Atlassian product, and you're all set.

    How can I buy apps for my legacy Jira Server or Confluence Server license?

    If you own a legacy Jira Server Unlimited (100+ users) or Confluence Server Unlimited (2000+ users) license purchased in 2012 or earlier, legacy app pricing is no longer available. You have two options for app purchasing:

    • Purchase the app at the non-legacy Unlimited (10000+ users) tier.
    • Renew your Jira or Confluence license at a non-legacy tier, then purchase the app at the same tier.

    Learn more

    M20 Technology LLC provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this app.

    Versions

    Version 2.9.1 • Confluence Server 6.1.0 - 7.6.2 • Released 2020-06-26

    Summary

    Bugfix Release

    Details

    • Fix a bug in SQL Variable macro preventing table values to be used multiple times

    Installation

    1. Log into your Confluence instance as an admin.
    2. Click the admin dropdown and choose Atlassian Marketplace. The Manage add-ons screen loads.
    3. Click Find new apps or Find new add-ons from the left-hand side of the page.
    4. Locate Reporting Connector for SQL Databases via search. The appropriate app version appears in the search results.
    5. Click Try free to begin a new trial or Buy now to purchase a license for Reporting Connector for SQL Databases. You're prompted to log into MyAtlassian. Reporting Connector for SQL Databases begins to download.
    6. Enter your information and click Generate license when redirected to MyAtlassian.
    7. Click Apply license. If you're using an older version of UPM, you can copy and paste the license into your Confluence instance.

    To find older Reporting Connector for SQL Databases versions compatible with your instance, you can look through our version history page.

    Similar apps