Skip to content

Etendo BI Bundle

Javapackage: com.etendoerp.etendobi.extensions


In this section, the user can find technical information about the Etendo BI Bundle.

Etendo BI Connector

Technical Aspects

To ensure proper functioning of the script, follow the steps below:


The following steps can only be used for Linux OS.

  1. rsync must be installed in our system, since this is the tool we use to connect to the server.

    sudo apt install rsync
  2. Make sure you have at least python3.7 or above installed on your system. You can verify the installation by running

    python3 --version

    If it is not installed, run

    sudo apt update && sudo apt install python3
    And then verify that the version is correct.

  3. It is highly likely that pip3 comes bundled with the installation of python3. Verify if it is installed by running

    pip3 --version

    Then ensure to have an updated version of it

    sudo pip3 install --upgrade pip

    If it is not installed, run

    sudo apt install python3-pip
  4. The user needs to install libpq-dev to ensure seamless communication and compatibility between our python script and the postgresql database.

    To install it, run

    sudo apt install libpq-dev

  5. The following libraries need to be installed using pip3 for them to work: psycopg2, pandas and requests. You can install them by running:

    pip3 install psycopg2-binary
    pip3 install pandas
    pip3 install requests

Etendo BI Connector

After the execution of the process, two new directories should be created in the filesystem. One will contain the logs files, one for the rsync execution that will contain information about the file upload to the server; another file called syncScript.log.{datetime}, that will contain information about the script execution (most of this information can be seen in the Logs Monitor window, but if for any reason the window cannot receive this information, it should be able to be seen using this .log file).

In this example, in the path where the script is allocated, a new directory named “Etendo” should be created. Inside it, there should be two folders for the organization that set the background process (F&B US West Coast).

drwxrwxr-x 1 <user> <group> 9,1K jun 8 16:52

drwxrwxr-x 4 <user> <group> 4,0K jun 8 17:39 Etendo/

Inside the Etendo/ folder, we have:

drwxrwxr-x 2 <user> <group> 4,0K jun 8 16:54 F+B_US_West_Coast_logs/

drwxrwxr-x 2 <user> <group> 4,0K jun 8 16:54 F+B_US_West_Coast_output/

The output directory, will contain all the CSVs that should have been uploaded to the server.


Remember that the main folder is created using the prefix of the “Client” variable that is set on BI Connection window. If two connections have the same value for “Client” variable, these directories will be overwritten.

This is the content of Ete_Example.csv and BASE_Example.csv files: 


Remember that since any column is not being overridden, these files are the same. 

On the other hand, this is the content of FULL_Example.csv:


Make sure to have the corresponding permissions to connect to Files, since an incorrect configuration can lead to an error.