Skip to:

SQL for Bamboo

SQL for Bamboo

by

Appfire

This app has been archived. The contents of this page may by outdated. You may still get support information and download previous versions of this app. Learn more

Support

This is a supported app, so you may contact the partner (or support contact) for help:

Visit partner profile

To check known issues (or if you want to file one), view this app's issue tracker.

To learn more about the app, you should:

App Description

Inspired by our popular SQL for Confluence app

Inspired by the outstanding customer response to our top-selling SQL for Confluence app, we created SQL for Bamboo.

Leverage Bamboo tasks to run dynamic SQL

The app 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.

Simple configuration, powerful output

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

Highlights:

  • Supports JDBC compliant databases, such as Microsoft SQL Server, Oracle, PostgreSQL, MySQL, and DB2
  • File or inline SQL scripts can be 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

Appfire helps great makers build what's next. Our growing portfolio of apps empowers teams worldwide with workflow automation, business intelligence, and administration at scale.

Version History

This app has: