1,825
Customers have installed this app in at least 1,825 active instances.
    by cPrimeTop Vendor
    cPrime is a Top Vendor. Top Vendors have high standards for app quality, reliability, and support.

    Learn more

    for Jira Server 7.0.0 - 7.12.3 and more versions
    Versions available for Jira Server 4.3 - 5.2.11
    Jira Server 5.3.0.next3 - 6.4.14
    Unsupported
    Jira Service Desk
    This app is compatible with Jira Service Desk.
    Supported
    cPrime supports this app.

    Get support

    Jira Service Desk
    This app is compatible with Jira Service Desk.
    Unsupported
    Jira Service Desk
    This app is compatible with Jira Service Desk.

    Execute queries to external databases or SIL scripts and display extracted data in configurable database custom fields in Jira

    Execute queries to external databases or SIL scripts and display extracted data in configurable database custom fields in Jira

    Execute queries to external databases or SIL scripts and display extracted data in configurable database custom fields in Jira

    Use external data in configurable custom fields

    One stop reporting solution for importing data

    Our database fields are indexed in Jira

    Instantly build information and remove the need for manual entry by importing external data sources into Jira.

    Populate custom fields with remote data sources like SQL database using cascading selections and autocomplete text boxes. Use table view to easily display data.

    Our database fields are indexed in Jira which means you can run reports on them even if information is extracted from the database. We provide support for your reporting gadgets.

    More details

    This popular Jira plug in speeds up automation and is a must-have for any Jira admin's toolbox. Query external data sources and retrieve dynamic information from external systems which is automatically integrated into Jira tickets.

    Process data with a SIL scripting language that we built exclusively for cPrime's Power Portfolio apps.

    Online stores are managing orders, hospitals work with patient info, support teams are working in Jira Service Desk, internal teams manage financials, candidates, and so on - all using database custom fields.

    Key features

    • Easy configurability
    • Data Center, JSD support
    • Advanced search
    • We work with files too
    • Table view
    • Restrict data from certain users
    • Export to CSV
    • and many more!

    Use Power Database Fields PRO™ with other cPrime Power Portfolio apps like Power Scripts™ and harness our Simple Issue Language™ which we have exclusively built for our apps. For huge select lists, take a look at our Power Custom fields PRO™.

    Learn more here.

    Reviews for cloud

    (42)
    Sign in to write a review
    by sivabalan N on 2017-08-29
    Plugin is awesome. I saw the limitation like sql query will work only less 10K records. Whether if table contains 10K or fetching the records upto 10K records. Can you please confirm. Thanks Sivabalan N.
    Was this review helpful?YesNo
    cPrime

    Hi Sivabalan,

    Thank you for the review!

    The 10K could be considered a soft limitation as we do not say it won't work, it's that we only guarantee the 10K but it's up to you to try with more records.

    Feel free to contact our support if you have more questions.

    Cheers!

    by Muhamed Buzaljko on 2017-06-30
    Very useful plugin. Any news about the support for v7.4? Thanks!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    cPrime

    Hi Muhamed,

    Thank you for a kind review. Regarding compatibility, we're already working on it, so stay tuned for a new plugin version soon.

    Update: and it's here! :)

    Cheers!

    by IS4IT Atlassian on 2017-04-03
    A good plugin with nice features. But one critical bug for the customers: If I have a set of database fields on a create screen and I move one of the fields to an another tab, the data in the field does not load. When moved back, the field loads the data. Please have a look at that. Thanks! Radim
    Was this review helpful?YesNo
    cPrime

    Hi Radim,

    Thank you for taking time to write a review. We have tested the plugin and noticed that dependency still works even if the parent field is on another tab (at least in the 4.0.0 version). We would like to reproduce your issue and help you, and would appreciate if you give us more details on it here:

    https://jira.cprime.io/servicedesk/customer/portal/2

    by rTrack Support on 2016-12-20
    Hi Team , we have recently tried to use this plugin .we have tried in test server .its working fine .But when i tried to install it in my production server its not working .Please help me on this . it throws the error as Database JNDI is not defined . Possible database misconfiguration ? could not execute sql query Please help me to resolve this .
    Was this review helpful?YesNo
    by Jean-Francois Allot on 2016-11-23
    When using this plugin to access tables already available in the Jira database, I am worried to be forced to duplicate the database parameters in context.xml while there are already declared in dbconfig.xml: can't the plugIn use the "defaultDS" already defined in Jira? (the documentation at https://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration doesn't explain if the defaultDS can be used) Thanx
    Was this review helpful?YesNo

    Reviews for server

    (42)
    Sign in to write a review
    by Radhouene Aouni on 2018-04-11
    Awesome plugin! I really find it very useful. I just have a small comment. It seems like you forgot that the console is debugging "tralala" in the function "doGridResize".
    Was this review helpful?YesNo
    cPrime

    Hi, Radhouene, appreciate your kind words, thank you!

    Good catch on the note, we'll fix this for the next release.Cheers!

    by Jonathan Muse on 2017-12-06
    I love this plugin and have been using it for years. The autocomplete is very powerful and the SIL tables offer endless possibilities for further customization. For me, the performance of the database fields have always matched the performance of the query run directly in the database, I have had a couple queries run slow (both as a custom field and directly in the database) but once I got some help cleaning up the SQL the custom field performed very nicely.
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    cPrime

    Thank you, Jonathan!

    We're happy the app brings value for you and whenever you have a question or an idea for a new feature you can always let us know here.

    Regards,

    Products Team

    by Ethan Foulkes on 2017-12-03
    Big fan of this add-on and I'm personally happy this is moving to paid as it means resources are being put behind it to improve and maintain. I know it's frustrating to users, especially when getting approval for funds is difficult, but keep in mind the alternative which is when free add-ons get abandoned.
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    cPrime

    Thank you so much, Ethan!

    You are exactly right, we plan to continue to invest into Power Database Fields PRO and will continue to bring value and new features to our users. If you ever have an idea for a feature, please let us know - we're just one click away!

    Regards,Products Team

    by sudhakar reddy on 2017-10-03
    Can you please explain how SQL queries execute. We configure Parameters for the Database Custom Field in that SQL query also one, now the hard part is we need to give custom field as hard coded like rel.textvalue = {customfield_10135}. Now if we want to move from dev to production these custom field IDs will get changes so please advice best way to use IT. Also please let me know where SQL queries will store in JIRA Database once we configure.
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    cPrime

    Hi there and thank you so much for your kind feedback.

    Regarding your request, you can check out the Power Database Fields documentation or reach out to us via our support portal and our Products Team will help you with it.

    Cheers!

    by sivabalan N on 2017-08-29
    Plugin is awesome. I saw the limitation like sql query will work only less 10K records. Whether if table contains 10K or fetching the records upto 10K records. Can you please confirm. Thanks Sivabalan N.
    Was this review helpful?YesNo
    cPrime

    Hi Sivabalan,

    Thank you for the review!

    The 10K could be considered a soft limitation as we do not say it won't work, it's that we only guarantee the 10K but it's up to you to try with more records.

    Feel free to contact our support if you have more questions.

    Cheers!

    Reviews for Data Center

    (42)
    Sign in to write a review
    by sivabalan N on 2017-08-29
    Plugin is awesome. I saw the limitation like sql query will work only less 10K records. Whether if table contains 10K or fetching the records upto 10K records. Can you please confirm. Thanks Sivabalan N.
    Was this review helpful?YesNo
    cPrime

    Hi Sivabalan,

    Thank you for the review!

    The 10K could be considered a soft limitation as we do not say it won't work, it's that we only guarantee the 10K but it's up to you to try with more records.

    Feel free to contact our support if you have more questions.

    Cheers!

    by Muhamed Buzaljko on 2017-06-30
    Very useful plugin. Any news about the support for v7.4? Thanks!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    cPrime

    Hi Muhamed,

    Thank you for a kind review. Regarding compatibility, we're already working on it, so stay tuned for a new plugin version soon.

    Update: and it's here! :)

    Cheers!

    by IS4IT Atlassian on 2017-04-03
    A good plugin with nice features. But one critical bug for the customers: If I have a set of database fields on a create screen and I move one of the fields to an another tab, the data in the field does not load. When moved back, the field loads the data. Please have a look at that. Thanks! Radim
    Was this review helpful?YesNo
    cPrime

    Hi Radim,

    Thank you for taking time to write a review. We have tested the plugin and noticed that dependency still works even if the parent field is on another tab (at least in the 4.0.0 version). We would like to reproduce your issue and help you, and would appreciate if you give us more details on it here:

    https://jira.cprime.io/servicedesk/customer/portal/2

    by rTrack Support on 2016-12-20
    Hi Team , we have recently tried to use this plugin .we have tried in test server .its working fine .But when i tried to install it in my production server its not working .Please help me on this . it throws the error as Database JNDI is not defined . Possible database misconfiguration ? could not execute sql query Please help me to resolve this .
    Was this review helpful?YesNo
    by Jean-Francois Allot on 2016-11-23
    When using this plugin to access tables already available in the Jira database, I am worried to be forced to duplicate the database parameters in context.xml while there are already declared in dbconfig.xml: can't the plugIn use the "defaultDS" already defined in Jira? (the documentation at https://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration doesn't explain if the defaultDS can be used) Thanx
    Was this review helpful?YesNo

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    10 users$1025 users$5050 users$100100 users$350250 users$1,000500 & 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. For Jira 7.0 or later, the app tier should match the maximum tier of the licensed Jira products on your instance. For example, if you're running Jira Software (500 users) and Jira Service Desk (25 agents) on the same instance, you should purchase the 500-user tier for apps. For versions of Jira prior to 7.0, the app tier should match the licensed user tier for Jira. Even if fewer users want to use the app than your Jira license, the two licenses should match exactly. Note: While this app has features specific to Jira Service Desk, the app is technically available across the whole Jira instance. Therefore the above guidelines for the license tier still apply.

    Can I install this app in a Data Center product?

    This app does not have a 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

    cPrime is a  Top Vendor, committed to providing support for their apps at least 8 hours a day, 5 days a week.

    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 4.0.12 Jira Server 7.0.0 - 7.12.3 Released 2018-05-23

    Summary

    Performance enhancements when working with huge data sets

    Details

    • Added caching for the Database custom fields to improve performance when working with huge datasets.
    • Minor bug fixes
    • Compatibility updates

    Installation

    1. Log into your Jira instance as an admin.
    2. Click the admin dropdown and choose Atlassian Marketplace. The Manage add-ons screen loads.
    3. Click Find new add-ons from the left-hand side of the page.
    4. Locate Power Database Fields PRO™-External Data 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 Power Database Fields PRO™-External Data. You're prompted to log into MyAtlassian. Power Database Fields PRO™-External Data 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 Jira instance.

    To find older Power Database Fields PRO™-External Data versions compatible with your instance, you can look through our version history page.

    Similar apps