<< Click to Display Table of Contents >> Navigation:  Connectors > SAP HANA

Overview

The SAP HANA connector for Bizagi is available for download at Bizagi Connectors Xchange.

Through this connector, you will be able to connect your Bizagi processes to a SAP HANA Database system hosted in SAP Cloud Platform.

For more information about this connector's capabilities, visit Bizagi Connectors Xchange.

 

Before you start

In order to test and use this connector, you will need:

1.Bizagi Studio previously installed.

2.This connector previously installed, via the Connectors Xchange as described at https://help.bizagi.com/platform/en/index.html?Connectors_Xchange.htm, or through a manual installation as described at https://help.bizagi.com/platform/en/index.html?connectors_setup.htm

3.A valid SAP Cloud Platform account. You can follow this guideline in order to sign up for a free trial account on SAP Cloud Platform.

4.A trial or production server hosted in SAP HANA with a database schema.

If you want to create a trial environment, log into https://account.hanatrial.ondemand.com/#/home/welcome. Using trial environments, your instance will keep started during 12 hours, when this time is over, you can start it back again as many times as you need.

 

Configuring the connector

In order to configure the connector (i.e its authentication parameters), follow the steps presented at the Configuration chapter in https://help.bizagi.com/platform/en/index.html?connectors_setup.htm

 

 

For this configuration, consider the following authentication parameters:

•Authentication method: Custom.

•host: System database host.

•databaseName: The name of the database to connect to.

•instanceNumber: Instance of the number of HANA system (optional).

•port: System database port (optional).

•user: The username which has access to that database. Notice you should also make sure that such user has write or read access, according to the type of query you want to run.

•password: The password for the user.

 

You can use either an instanceNumber or the port for your connection, they are both optional but one of them is required.

 

 

 

Using the connector

This connector features connectivity to a SAP HANA database instance.

To learn overall how/where to configure the use of a connector, refer to https://help.bizagi.com/platform/en/index.html?Connectors_Studio.htm.  

When using the connector, make sure you consider the following details for the available method.

 

Run Query

This method allows you to run a query directly at SAP HANA database.

 

 

To configure its inputs, consider:

•queryString: The SQL statement to be executed by SAP HANA database (e.g INSERT INTO...)

•statementType: A string to define the type query to be run. Possible values are direct, prepared and stored-procedure.

•params: A string containing all the parameters for the query. Parameters should be between a pair of pipes “|” and separated by commas “,”. params replace the question symbols "?" sent in the queryString.

Params are used when the statementType is prepared or stored-procedure.

For stored procedures, the params number should be equal to the number of inputs of the procedure, but the number of question mark symbols “?” in the queryString should include the number of outputs.

Example: |2016-04-14|, |123|, |13:32:20|, |XYZ001|.

 

 

To configure its outputs when getting started and testing, you may map res (e.g, notifying about a successful INSERT clause operation).

 

 

For more information about this method's use, refer to SAP HANA’s unofficial database client documentation at https://github.com/SAP/node-hdb.

Last Updated 10/27/2022 11:50:56 AM