Prerequisites for Connectors

apt install libaio1

Installing Microsoft SQL Server ODBC Driver

To install the database driver:

On Windows

1. Download the Microsoft SQL Server ODBC Driver MSI installer file from the Microsoft website.

2. Run the executable installer.

Microsoft SQL Server ODBC Driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.

On macOS and Ubuntu

To install the Microsoft ODBC Driver for SQL Server:

• Microsoft ODBC driver for SQL Server - macOS
• Microsoft ODBC driver for SQL Server - Ubuntu

Microsoft SQL Server ODBC Driver is now visible in the odbcinst.ini file with the driver path.

Installing PostgreSQL and Greenplum ODBC Drivers

To install the PostgreSQL and Greenplum ODBC drivers on specific platforms:

On Windows

1. Download the PostgreSQL ODBC Driver MSI Installer file from https://odbc.postgresql.org/.

2. Run the executable installer.

   Result

   After installation, the PostgreSQL ODBC Driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.

On macOS

1. Run the following command:

   brew install psqlodbc

   The driver is installed at the default location.

   For example: /usr/local/Cellar/psqlodbc/16.00.0000/lib/psqlodbcw.so or /opt/homebrew/Cellar/psqlodbc/16.00.0000/lib/psqlodbcw.so

2. Edit the odbcinst.ini file with the following text with driver file path and name as per your system.

   [PostgreSQL]
   Description=PostgreSQL ODBC Driver
   Driver=<default driver location>

On Ubuntu

• Run the following command:

apt install odbc-postgresql

On Ubuntu

1. Download the driver file provided by Amazon.

2. Run the executable installer.

For more information, see Amazon Redshift Documentation.

Installing Snowflake ODBC Drivers

To install the Snowflake ODBC drivers on specific platforms:

On Windows

1. Download and install the MSI Installer file from the Snowflake ODBC installation page.

2. Configure the ODBC Driver. Ensure that you see an entry for SnowflakeDSIIDriver in the ODBC Data Source Administrator(x64) program under the Drivers tab.

   1. Open the Windows Data Source Administration tool.

   2. Verify if the Snowflake ODBC driver is installed.

   3. Create a new data source name (DSN).

On macOS

1. Download the Snowflake ODBC driver installer from the Snowflake website.

2. Mount and install the package as mentioned here.

If you choose the default directory when prompted, the installer installs the ODBC driver files in the /opt/snowflake/snowflakeodbc/Library/ODBC directory.

To create a DSN, edit the appropriate odbc.ini file.

On Ubuntu

• Download and extract the TGZ file. Install and set up the ODBC driver as described in the Snowflake documentation.

• Configure the environment with unixODBC.

In a terminal window, change to the snowflake_odbc directory, and run the ./unixodbc_setup.sh command to install the Snowflake ODBC.

This script completes the following:

• Adds a Snowflake connection to your system-level /etc/odbc.ini file.

• Adds the Snowflake driver information to your system-level /etc/odbcinst.ini file.

• Adds the certificate authority (CA) certificates required by the Snowflake ODBC driver to your system-level simba.snowflake.ini file.

• By running the unixodbc_setup.sh command, you do not need to set any environment variables.

Setting up EMS for Local Runtime

• For Windows

  1. Download the TIBCO Enterprise Message Service™ (EMS) Client package from TIBCO eDelivery and extract to TIB_ems_<version>_win_x86_64/TIB_ems_<version>.

  2. Set the EMS_HOME environment variable.

  3. Set the EMS_HOME=<EMS installation path>.

  4. For running the binary, add the following to the system path:

     <EMS installation path>\<version>\bin

  5. Install PowerShell on Windows and then run Get-ExecutionPolicy.

  6. If it returns the status as "restricted", then run Set-ExecutionPolicy AllSigned.

  7. From HELP AND FEEDBACK, select Install Prerequisites for Flogo Connectors.

  8. Install the Tibco EMS/FTL/ActiveSpaces prerequisite option to set up gcc.

  9. Install the Tibco EMS/FTL/ActiveSpaces prerequisite option to set up pkg-config.

• For macOS

  1. Download the TIBCO Enterprise Message Service™ (EMS) Client package from TIBCO eDelivery and extract to TIB_ems_<version>_macosx_x86_64/TIB_ems_<version>.

  2. Set the EMS_HOME environment variable.

     export EMS_HOME=<EMS installation path>

  3. Install Xcode IDE.

     Xcode-select –install

  4. To run the binary, export DYLD_LIBRARY_PATH.

     export DYLD_LIBRARY_PATH=<EMS installation path>/lib

• For Linux

  1. Download the TIBCO Enterprise Message Service™ (EMS) Client package from TIBCO eDelivery and extract to TIB_ems_<version>_linux_x86_64/TIB_ems_<version>.

  2. Run the following commands:

     • sudo su

     • for f in tar/*; do tar -C / -xvf $f;

  3. Set the following variables in the ./bashrc directory:

     • Export LD_LIBRARY_PATH=<EMS installation path>/<version>/lib

     • Export EMS_HOME=<EMS installation path>/<version>

  4. From HELP AND FEEDBACK, select Install Prerequisites for Flogo Connectors.

  5. Install the Tibco EMS/FTL/ActiveSpaces prerequisite option to set up pkg-config.

  Note: EMS installation for ARM-based machines is not supported. Therefore, EMS binary generation, Docker image generation, and unit testing is not supported in ARM-based machines.

Setting up SAP Solutions

Prerequisites

Ensure that the following requirements are met before proceeding:

Platform Limitations

Due to an OS-specific dependency on the NW RFC SDK, application executables using the Flogo® Connector for SAP Solutions cannot be built for Windows and macOS with the TIBCO Control Plane runtime.

When using a local runtime, building a cross-platform executable (such as a Linux executable on a Windows machine) is not supported.

Required Software

• SAP NWRFC SDK 7.50 PL17 or later must be downloaded and installed locally.

• The gcc tool must be installed on your machine.

• For Windows: The Visual C++ Redistributable Package for Visual Studio 2013 or later is required.

Configuring Flogo Connector for SAP Solutions in VS Code

To configure Flogo Connector for SAP Solutions, perform the following steps:

Procedure

1. Download the SAP NWRFC SDK for your operating system.

2. Extract the SDK to a local directory (for example, C:\nwrfcsdk), ensuring that lib and include subdirectories are present.

3. In Visual Studio Code where the Flogo extension is installed, navigate to Settings.

4. Use the search bar to find Flogo.

5. Locate the setting labeled Flogo > Extensions: SAPNWRFC Home.

6. Enter the full path to your extracted SDK directory in the corresponding text box (for example, C:\nwrfcsdk).

Setting up the Runtime Environment

To run a built application containing the SAP Solutions connector, you must update the environment variables for your operating system.

• For Windows

  Add the following script to the system PATH environment variable:

  <SAP NWRFC SDK installation path>\lib

• For Linux

  Set the following variable:

  export LD_LIBRARY_PATH=<SAP NWRFC SDK installation path>/lib

• For macOS

  Set the following variable:

  export DYLD_LIBRARY_PATH=<SAP NWRFC SDK installation path>/lib

Setting up FTL for Local Runtime

For Windows

1. From TIBCO eDelivery, download the Windows TIBCO FTL package.

2. Extract the contents of the downloaded package to a local directory.

3. Run the installer file and complete the installation.

4. Confirm that the installation is successful.

5. If gcc is not already installed, from HELP AND FEEDBACK, select Install Prerequisites for Flogo Connectors and install the Tibco EMS/FTL/ActiveSpaces prerequisite option.

6. Set the TIBFTL_ROOT environment variable.

   TIBFTL_ROOT=<ftl_installation_path>\ftl\<x.x>

   For example, TIBFTL_ROOT=C:\tibco\ftl\7.1

7. Add the following path to the PATH environment variable:

   <ftl_installation_path>\ftl\<x.x>\bin

   For example, C:\tibco\ftl\7.1\bin

   After updating the environment variables, restart or reload the Visual Studio Code window.

For Linux

1. From TIBCO eDelivery, download the Linux TIBCO FTL package.

2. Extract the downloaded package.

3. Run the following commands to install the package:

   1. sudo su

   2. for f in tar/*; do tar -C / -xvf $f;

4. Confirm that the installation of the driver is successful.

5. Set the required environment variables:

   export TIBFTL_ROOT=<ftl_installation_path>\ftl\<x.x>

   export LD_LIBRARY_PATH=<FTL installation path>/<version>/lib

   For example, export TIBFTL_ROOT=/opt/tibco/ftl/7.1

   export LD_LIBRARY_PATH=/opt/tibco/ftl/7.1/lib:$LD_LIBRARY_PATH

6. Add the FTL bin directory to the PATH variable:

   export PATH=$PATH:<ftl_installation_path>/ftl/<version>/bin

   For example, export PATH=$PATH:/opt/tibco/ftl/7.1/bin

   After updating the environment variables, restart or reload the Visual Studio Code window.

Setting up ActiveSpaces for Local Runtime

Prior to using this connection, Flogo Connector for ActiveSpaces DataGrid needs to be installed and setup. Ensure that the following steps are completed before using this connector.

1. Set environment variable, TIBDG_ROOT to <activespace_installation_path>\as\<x.x>.

2. Set environment variable, TIBFTL_ROOT to <ftl_installation_path>\ftl\<x.x>.

3. Add the below paths in the PATH variable:

   • <activespace_installation_path>\as\<x.x>\bin

   • <ftl_installation_path>\ftl\<x.x>\bin

4. If gcc is not already installed, from HELP AND FEEDBACK, select Install Prerequisites for Flogo Connectors and install the Tibco EMS/FTL/ActiveSpaces prerequisite option.

After adding the environment variables, restart or reload the VS Code window.