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.