Primo.Sap.Data.Hana 1.0.0

About

The package contains elements of interaction with SAP HANA database for designing (both UI and coded) automation programs in Primo RPA studio, and then executing them by the Primo RPA robot.

How to Use

In Primo RPA studio, create a project that will be executed by Primo RPA robot. Install this package via the ".Dependencies → Manage Dependencies" menu; the "Detabase → SAP HANA" node with package elements will appear in Elements tree .
There are four elements in the package: "Connect (SAP HANA)", "Execute Query (SAP HANA)", "Insert (SAP HANA)", "Disconnect DB (SAP HANA)". "Connect (SAP HANA)" is the main one, because it is not possible to interact with any DB without connecting. It is highly recommended to use the "Disconnect DB (SAP HANA)" element after interacting with the database to free up external resources.
In pure code projects use the "Connect (SAP HANA)" element as follows:

//wf: [LTools.Common.Model.WorkflowData] parent algorithm link
//db - Connection string: [String] Database connection string (SERVER=<hostname>:<port>; DATABASE=<database name>; UID=<username>;PWD=<password>)
Primo.Sap.Data.Hana.DatabaseApp app = LTools.Database.DatabaseApp.Init(wf, db);

Pure code for "Insert (SAP HANA)" element:

//app - [Primo.Sap.Data.Hana.DatabaseApp] DB application
//query - Table: [String] Table name
//data - Data: [System.Data.DataTable] Data to insert
//timeOut - Time-out: [Int32] Query time-out
//res - Records: [Int32] Affected records
//exactColumns - Exact columns mapping: [Boolean] All columns from the source table or only matching ones are imported into the database
//useTransaction - Use transaction: If there is an error  rollback the insert operation
int res = app.Insert(query, data, [timeOut], [exactColumns], [useTransaction]);

Key Features

• User-friendly, intuitive interface
• High performance
• Supports .NET Framework 4.6.1+

Main Types

• Primo.Sap.Data.Hana.DatabaseInst
• Primo.Sap.Data.Hana.DatabaseApp
• Primo.Sap.Data.Hana.Elements.WFConnectDatabase
• Primo.Sap.Data.Hana.Elements.WFExecuteQuery
• Primo.Sap.Data.Hana.Elements.WFInsert
• Primo.Sap.Data.Hana.Elements.WFDisconnectDatabase

Feedback

Bug reports and contributions are welcome at Primo RPA chat