ODBC

This Data bridge leverages the BPPI API by querying (via SQL) an ODBC existing Data Source and pushing those query results into a BPPI Repository Table (it's also possible to execute some To Do lists afterwards). Using this bridge is pretty easy as you just have to launch a command line (CLI).

Capabilities

• Get Data from an ODBC Data Source and load it into the BPPI Repository.

Command line

• -sourcetype (Mandatory) odbc
• -configfile (Mandatory) Config file with all configuration details (INI format, see the template below) if a file is specified for the -configfile parameter the parameter file must follow the INI format rules. Example/Template -> see the config.ini-template (rename it as an *.ini file)

Example

Launch the program in the shell (windows or linux) command line like this:

$ python3 bppibridge.py -sourcetype odbc -configfile {config.ini}

The 5 mins configuration's stuff in video

Mandatory parameters in the Configuration file

Two parameters (in the database section) are mandatory for that specific connection:

• connectionstring specifies the ODBC connection String
• query specify the file in which the SQL query is stored

[database]
# SQL Server ODBC Connection string
connectionstring=DRIVER={ODBC Driver 18 for SQL Server};SERVER=localhost\SQLEXPRESS;DATABASE=blueprism;UID=*;PWD=***;ENCRYPT=No
# Filename with the query (SQL)
query={filename}

ODBC Connection String example

• For SQL Server: DRIVER={ODBC Driver 18 for SQL Server};SERVER=localhost\SQLEXPRESS;DATABASE=xxx;UID=xxx;PWD=xxx;ENCRYPT=No