2,063
Customers have installed this app in at least 2,063 active instances.
    by cPrimeAtlassian Verified
    cPrime is an Atlassian Verified vendor. Verified vendors demonstrate Atlassian standards for app quality, reliability, and support.

    Learn more

    for Jira Server 7.0.0 - 7.6.1 and more versions
    Versions available for Jira Server 4.3 - 5.2.11
    Jira Server 6.0-m06.1 - 6.4.14
    Unsupported
    Jira Service Desk
    This app is compatible with Jira Service Desk.
    Supported
    cPrime supports this app.

    Get support

    Data Center
    This app is compatible with the clustering and high-availability capabilities of our products.
    Jira Service Desk
    This app is compatible with Jira Service Desk.

    Execute any types of queries to external databases or SIL scripts and display data in the database custom field in Jira

    Execute any types of queries to external databases or SIL scripts and display data in the database custom field in Jira

    Configuration is just easy

    Tables can be scripted

    Our database fields are indexed in Jira

    Ease of Power Database Fields PRO configuration will save your time. Apart from the datasource, you do not need to edit any files.

    Sometimes, just showing data from a database is not enough. If you need to process it first, here's how you can do it with a SIL scripting language that we built exclusively for our power portfolio apps.

    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

    Power Database Fields PRO is the most popular database app to help you extract data from external databases or SIL scripts and display it in Jira tickets.

    Online stores use it for adding details to their orders, pharmaceutical companies and hospitals use it for managing prescription and patient info, Support teams leverage its functionality in Jira Service Desk, internal teams manage financials, candidates, and inventory information using the power of database fields.

    Here’s some of features our users love:

    • Easy configurability
    • Data Center support
    • Jira Service Desk support
    • Advanced search
    • Works even with files
    • Table view inside Jira ticket
    • Ability to restrict data from certain users
    • Export to CSV
    • and many more

    Additionally, Power Database Fields PRO is great for you if you’re already using our power portfolio apps like Power Scripts. Our apps leverage one scripting language – Simple Issue Language or SIL which we have exclusively built for our power portfolio apps.

    Learn more here.

    Reviews for cloud

    (41)
    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

    (41)
    Sign in to write a review
    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 TU Graz Zentraler Informatikdienst on 2017-10-13
    It's not installing sauber
    0 out of 1 found this review helpful
    Was this review helpful?YesNo
    cPrime

    Hi there,

    Sorry to see this feedback. Would you mind letting us know more details about what didn't work for you so that we can help you install and configure it properly.

    We'd love to help and turn this review into a 4 star one.

    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!

    Pricing

    10 users$1025 users$5050 users$100100 users$350250 users$1000500 & upAdditional pricing details

    Paid-via-Atlassian pricing FAQ

    How does server app pricing work?

    Server products and apps are hosted on your servers. Licenses are perpetual and the purchase price include 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 host 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 host product. For Jira Server 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 (50 users) and Jira Service Desk (10 agents) on the same instance, you should purchase the 50-user tier for apps. For versions of Jira Server 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.

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

    For server apps, purchase and renewal is half-price if you have an academic license for your Atlassian host product. Server apps are always free for community and open-source licenses.

    For more details about qualifying for special licenses, see here.

    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 host 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 an Atlassian Verified 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.7 Jira Server 7.0.0 - 7.6.1 Released 2017-11-29

    Summary

    Licensing release, compatibility release

    Details

    • Added licensing
    • added compatibility with the latest Jira version
    • added compatibility with the latest Jira Service Desk version

    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 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. You're prompted to log into MyAtlassian. Power Database Fields PRO 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 versions compatible with your instance, you can look through our version history page.

    Similar apps