Linx Training Resources

This post contains the details to be used in the training tutorial video. For this exercise, you will build an application that will retrieve data from an API and load it into a database. This is to be done on a schedule that executes every 15 minutes. Additional logging can be added to the process to log that an action has been done.

The link to the video will be added when it is up on YouTube.

The Process

Resources:

Here are the resources that you will need to complete the training exercise:

API

Database:

Here is the SQLite database:
TrainingDB.zip (492 Bytes)

Unzip it and place it somewhere - this is the database you will be setting up in the ODBC connection.

Alternatively, you can create the tables on your own database and connect to that:

Setup

Before you start building in Linx, you need to set up your database environment. You can use any database technology you want, however in the tutorial video a specific SQLite database is used. You will need to set up the ODBC connection to connect to this database. This can be done with the following steps:

  1. Download and install the SQLite ODBC driver from: [SQLite ODBC Driver (ch-werner.de)](SQLite ODBC Driver)

  2. Specifically, you will need to download sqliteodbc_w64.exe: http://www.ch-werner.de/sqliteodbc/sqliteodbc_w64.exe

  3. Download the database from above and unzip the file into a folder on your computer

  4. You can now connect to the SQLite database in Linx by using a properly configured connection string. The connection string will have the following format:

Driver={SQLite3 ODBC Driver};Database=MyFilePath;

MyFilePath will be the full file path of the database, so if you placed it in C:\Training\DB\ you will have a connection string that looks like this:

Driver={SQLite3 ODBC Driver};Database=C:\Training\DB\TrainingDB.db;

See Connection Editor for more details.