Connecting to remote databases with Power Scripts for Jira cloud
- Admin Adminovich (Deactivated)
- Jonathan Muse
- Elena Kolesnik
- Alexandra Topoloaga (Unlicensed)
Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8 for Server/Data Center? Click here !
Setting up connection to the external the datasources in cloud works in the same way as for the server one.
However, while on the server version of Power Scripts™ you have to have the JDBC Driver already loaded (for instance placed in the Jira lib folder), in cloud you cannot access that directory. Thus, we updated the Datasources page so that now you can add the JDBC drivers directly from the UI.
To add a new JDBC Driver, click the Choose File button, select your driver and then click Upload. The updated driver appears on the page.
To use the updated driver, go to SIL Engine™ Mgmt page and restart the engine.
You can now use the datasources on cloud as well! 
What's next
Now configure the datasources.
See also
- sql – Executes the SQL phrase over the defined datasource.
- sqlCallStoredProcedure – Executes the stored procedure over the defined datasource name / JNDI datasource.
- sqlCallStoredProcedureWithOutParams – Executes the stored procedure over the defined datasource.