38
Customers have installed this app in at least 38 active instances.
    by Bob Swift Atlassian Add-ons (an Appfire company)Atlassian Verified
    Bob Swift Atlassian Add-ons (an Appfire company) is an Atlassian Verified vendor. Atlassian Verified vendors demonstrate Atlassian standards for app quality, reliability, and support.

    Learn more

    for Bamboo Server 6.0.0 - 6.6.2 and more versions
    Versions available for Bamboo Server 5.9.0 - 5.15.7
    Supported
    Bob Swift Atlassian Add-ons (an Appfire company) supports this app.

    Get support

    Schedule your SQL statements and scripts to run dynamically in Bamboo

    Schedule your SQL statements and scripts to run dynamically in Bamboo

    Schedule your SQL statements and scripts to run dynamically in Bamboo

    Inspired by our popular SQL for Confluence add-on.

    Leverage Bamboo tasks to run dynamic SQL.

    Simple configuration. Powerful output.

    Inspired by the outstanding customer response to our top-selling SQL for Confluence add-on, the Bob Swift team is proud to announce our latest product: SQL for Bamboo

    The add-on provides Bamboo tasks for running dynamic SQL statements and scripts. Tasks can be used to manipulate or validate databases including custom conditions on results to determine task success or failure.

    Enables various database operations to be easily scheduled and managed in Bamboo. Result data can be output to a number of file formats. Create and manage test or production databases. Export results to other systems.

    More details

    FEATURES:

    • Supports JDBC compliant databases, such as Microsoft SQL Server, Oracle, PostgreSQL, MySQL, and DB2.
    • File or inline SQL scripts can de used with Bamboo variable replacement including support for nested variables.
    • Data source configuration data can be specified on a task basis or saved in a global or plan variable for reuse.
    • Multiple data sources can be accessed by using multiple tasks.
    • Multiple output formats are available:
      • Raw with line breaks
      • Raw
      • HTML
      • Confluence Wiki
    • Feed results to Bamboo variables for easy access by subsequent tasks and jobs.
    • Specify custom regex conditions for determining task success or failure.

    Reviews for cloud

    (0)Sign in to write a review

    There are no reviews yet. Be the first to review this app.

    Reviews for server

    (0)Sign in to write a review

    There are no reviews yet. Be the first to review this app.

    Reviews for Data Center

    (0)Sign in to write a review

    There are no reviews yet. Be the first to review this app.

    Cloud Pricing

    Server Pricing

    Data Center Pricing

      Local agents only
    10 jobs
    $100
    1 remote agent
    Unlimited jobs
    $100
    5 remote agents
    Unlimited jobs
    $250
    10 remote agents
    Unlimited jobs
    $500
    25 remote agents
    Unlimited jobs
    $1,000
    100 & 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 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

    Bob Swift Atlassian Add-ons (an Appfire company) 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.

    Community

    Community discussions connect you to the vendor and other customers who use this app.

    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 1.3.0 Bamboo Server 6.0.0 - 6.6.2 Released 2018-07-16

    Summary

    Nested variable support for SQL scripts, support latest Bamboo releases

    Installation

    1. Log into your Bamboo 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 SQL for Bamboo 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 SQL for Bamboo. You're prompted to log into MyAtlassian. SQL for Bamboo 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 Bamboo instance.

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

    Similar apps