2Copyright © 2002-2017 Bizagi. All rights reserved. 2
Table of Contents
Part I Configuring and using the SAPHANA connector 3
4Copyright © 2002-2017 Bizagi. All rights reserved.
Configuring and using the SAP HANA connector
OverviewThe 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 startIn 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
http://help.bizagi.com/bpmsuite/en/index.html?Connectors_Xchange.htm, or through a manual
installation as described at http://help.bizagi.com/bpmsuite/en/index.html?Connectors_install.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 connectorIn order to configure the connector (i.e its authentication parameters), follow the steps presented at the
Configuration chapter in http://help.bizagi.com/bpmsuite/en/index.html?Connectors_install.htm.
If you are using hanatrial.ondemand.com remote server, you cannot connect directly to the
database, you need to open a tunnel to do so.
For more information about this you can visit the following link that explains all the details:
https://help.sap.com/viewer/65de2977205c403bbc107264b8eccf4b/Cloud/en-
US/6930850a8f9a40489c01ed1aa381946d.html.
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 ensure 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.
5Copyright © 2002-2017 Bizagi. All rights reserved.
Using the connectorThis connector features connectivity to a SAP HANA database instance.
To learn overall how/where to configure the use of a connector, refer to
http://help.bizagi.com/bpmsuite/en/index.html?Connectors_Studio.htm.
When using the connector, ensure you consider the following details for the available method.
6Copyright © 2002-2017 Bizagi. All rights reserved.
Run QueryThis 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|.
7Copyright © 2002-2017 Bizagi. All rights reserved.
To configure its outputs when getting started and testing, you may map res (e.g, notifying about a
successful INSERT clause operation).
8Copyright © 2002-2017 Bizagi. All rights reserved.
For more information about this method's use, refer to SAP HANA’s unofficial database client
documentation at https://github.com/SAP/node-hdb.