Learn more
 

Connect to Jira Data from PowerBuilder


This article demonstrates how to access Jira data from PowerBuilder using the Jira JDBC Driver.

The CData JDBC driver for Jira is a standards-based control that can be used from any platform or development technology that supports JDBC, including PowerBuilder. This article shows how to use the CData JDBC Driver for Jira in PowerBuilder.

This article shows how to create a basic PowerBuilder application that uses the CData JDBC Driver for Jira to retrieve data.

About Jira Data Integration

CData simplifies access and integration of live Jira data. Our customers leverage CData connectivity to:

  • Gain bi-directional access to their Jira objects like issues, projects, and workflows.
  • Use SQL stored procedures to perform functional actions like changing issues status, creating custom fields, download or uploading an attachment, modifying or retrieving time tracking settings, and more.
  • Authenticate securely using a variety of methods, including username and password, OAuth, personal access token, API token, Crowd or OKTA SSO, LDAP, and more.

Most users leverage CData solutions to integrate Jira data with their database or data warehouse, whether that's using CData Sync directly or relying on CData's compatibility with platforms like SSIS or Azure Data Factory. Others are looking to get analytics and reporting on live Jira data from preferred analytics tools like Tableau and Power BI.

Learn more about how customers are seamlessly connecting to their Jira data to solve business problems from our blog: Drivers in Focus: Collaboration Tools.


Getting Started


Connect to Jira Data from PowerBuilder

Follow the steps below to use the Database Painter tool to create a database profile based on an JDBC URL for Jira. You can use a database profile to save connection properties. In the Database Painter, you can graphically manipulate data as well as execute SQL queries.

  1. Add the driver JAR to the PowerBuilder classpath. Set the CLASSPATH system environment variable to the path to the driver JAR, located in the lib subfolder of the installation directory.

    Note: If you are using PowerBuilder Classic, you can also add the path to the driver JAR by clicking Tools -> System Options -> Java.

  2. Click Tools -> Database Painter.
  3. Right-click the JDBC node and click New Profile.
  4. In the Database Profile Setup dialog, enter the following:
    • Profile Name: Enter a user-friendly name for the profile.
    • Driver Name: Enter the class name of the driver, cdata.jdbc.jira.JIRADriver
    • URL: Enter the JDBC URL.

      To connect to JIRA, provide the User and Password. Additionally, provide the Url; for example, https://yoursitename.atlassian.net.

      Built-in Connection String Designer

      For assistance in constructing the JDBC URL, use the connection string designer built into the Jira JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

      java -jar cdata.jdbc.jira.jar

      Fill in the connection properties and copy the connection string to the clipboard. A typical JDBC URL is below:

      jdbc:jira:User=admin;Password=123abc;Url=https://yoursitename.atlassian.net;
  5. To view and modify a table, right-click a table and then click Edit Data -> Grid.

Using Jira Data with PowerBuilder Controls

You can use standard PowerBuilder objects to connect to JDBC data sources and execute queries. The following example shows how to retrieve Jira data into a DataWindow. You can add the following code to the open method:

SQLCA.DBMS = "JDBC" SQLCA.AutoCommit = False SQLCA.DBParm = "Driver='cdata.jdbc.jira.JIRADriver',URL='jdbc:jira:User=admin;Password=123abc;Url=https://yoursitename.atlassian.net;"; CONNECT USING SQLCA; dw_issues.SetTransObject(SQLCA); dw_issues.Retrieve();

Ready to get started?

Download a free trial of the Jira Driver to get started:

 Download Now

Learn more:

Jira Icon Jira JDBC Driver

Rapidly create and deploy powerful Java applications that integrate with Jira including Customers, Inventory, Products, Orders, and more!

In this article

Related articles