How to install and configure the Xero Connector.

SQLite Database

Create a new SQLite Database for Xero Connector

Relative to the Apliqo FPM database create the folder ../[FPM]/ods/xero. The xero folder is the folder where the SQLite database and the xero connector software is to be located.

Using a program like DB Browser create a new SQLite database called ods_xero.sqlite.

In the new SQlite database create following tables and views. Hint, copy all the sql statements to the

Create ODBC connection to SQLite database

Create a ODBC connection, named xero_connector, to the ods_xero.sqlite database.

...

Copy the TM1 objects to Apliqo FPM.

Copy the TM1 objects that are in the TM1 Objects folder to the Data folder of Apliqo FPM database. Restart the Apliqo FPM TM1 service to read in the new TM1 objects. When the server restarts the }APQ C3 CNT Xero cube should appear.

Xero Connector

Update the tm1-config.ini

Copy the tm1-config.ini to the ../[FPM]/ods/xero folder create in step 1. This must be the same folder as the xeroconnector.exe located. In the tm1-config.ini update:

• address - The machine name on the network that hosts the TM1 database. If the xeroconnector.exe and the TM1 database are on the same machine, localhost can be used.

• port - The HTTPPortNumber parameter in the tm1s.cfg file for Apliqo FPM.

• user - The user the Xero Connector is to use when connecting to the Apliqo FPM TM1 database. This user must have Admin privileges in Apliqo FPM.

• password - The TM1 password for the user.

• ssl - True/False. The value of the UseSSL parameter in the tm1s.cfg file for Apliqo FPM.

• decode_b64 - True/False. To encrypt the user password in the file.

Add the TM1 Connection

In a command prompt navigate to the folder where the xeroconnector.exe is located. Next type the following command providing the --client_id,--client_secret and --description.

xeroconnector.exe --action="tm1_connection_add" --client_id="....1D8" --client_secret="....Mzd" --description="Xeno Group"

A new component will be added to the Connections consolidation in the }APQ C3 CNT Xero Tenant dimension. The principal name of the new element is the Connection ID used in subsequent commands.

Add the location to the SQLite database

In the }APQ C3 CNT Xero cube enter for the new connection:

• redirect URL - This is always https://xero.com/.

• sqlite_location - This is the full file name for the ods_xero.sqlite file.

Connect to Xero

In a command prompt navigate to the folder where the xeroconnector.exe is located. Next type the following command providing the --connection which is the Connection ID established above.

xeroconnector.exe --action="xero_connect" --connection="....E1D8"

This will open the Xero log in page. Provide your credencials and log in.

...

After logging into Xero, copy the concentid from the URL back in the command prompt window.

Set up the ODS

In a command prompt navigate to the folder where the xeroconnector.exe is located. Next type the following command providing the --connection which is the Connection ID established above.

xeroconnector.exe --action="ods_setup" --connection="....E1D8"

Import the organisations

In a command prompt navigate to the folder where the xeroconnector.exe is located. Next type the following command providing the --connection which is the Connection ID established above.

xeroconnector.exe --action="xero_import_organisations" --connection="....E1D8"

This will add the organisations element to the connection in the }APQ C3 CNT Xero Tenant dimension. Set the attribute “Active” to 1 for the organisations to be downloaded