SQL for Bamboo



NOTE: After careful consideration, as of July 1, 2023, this app has been retired and archived. Current customers will be supported until February 15th, 2024. Please contact our Support Team if you have any questions.

Description

This add-on provides Bamboo tasks for running dynamic SQL statements and scripts. Result data can be output to a file in a number of formats. This enables various database operations to be easily scheduled and managed in Bamboo. Create and manage test or production databases. Export database query results to Confluence or other systems.

Features

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


Related Add-ons

Run CLI Actions in Bamboo

  • Push SQL output to Confluence

Groovy Tasks for Bamboo 

  • Dynamically modify SQL scripts or output

SQL for Confluence

  • Consistent data source configuration

More Information

Marketplace

  • Downloads
  • Compatibility
  • Pricing

User's Guide


Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.


Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.