LLodi DB

Last updated 9 days ago

To see all the features for the LLodi DB Module, visit the API Reference.

Functionalities:

  • Send data to your own database from Qlik.

  • Store your data into files (plain text, csv, json, xml...)

Installation

For the moment it is required to contact with LLodi Support to get and install your LLodi DB instance.

Basic Configuration

Ports and Certificates

LLodi Agent supports both HTTP (by default, port 8098) and HTTPS (by default, port 8099).

You can modify the ports in your configuration tab.

Be sure that the chosen ports are available and open from where you are going to call them

Note that if you change the port it will change the url of your LLodi DB

{protocol}://{url}:{port}

To use HTTPS you must upload a certificate (PFX or PEM)in the configuration tab. When your certificate is correctly uploaded, the status will be "Active".

LLodi Key

To add an additional layer of security you can require a LLodi Key to be added to any request to your DB service.

Click on Refresh button to update your LLodi Key

LLodi Key is a unique GUID defined and activated from your LLodi DB. When enabled, it becomes required as the llodi-key header for any request. See line 12 in the example below.

Example from Qlik script using LLodi Connector
LIB CONNECT TO 'LLodi Writer Connector';
SELECT
FROM [DB update]
WITH GUID 123l4567-8l9o-0d1i-2a3l-456l7890od1i
WITH FIELDS (
"user" "Jhon",
"id" "44",
"email" "jhon.doe@email.com",
"department" "IT",
"city" "Calgary",
"comment" "This is a comment"
)
WITH CONNECTION (HTTPHEADER "Content-Type" "application/json",
URL " https://server.llodiserver.com:8099/odb?operation=replace&schema=test&table=users",
HTTPHEADER "llodi-key" "6f473260-1234-e433-98yt-2e1nov040159"
);

White-Lists

When enabled Whitelist feature will accept only IPs or domains on the list, blocking all others.

You can add your IP or domain to the list just clicking on the save button

DB Connections

Creating a connection

You can connect different databases to your LLodi DB. MySQL, Oracle and SQL Server are supported, but other types will be available soon.

If you change the port be sure that it is available.

Manage Connections

You can edit, delete or set default your existing connections. Your default database will be used if there is not a parameter that defines another database.

You can have more that one connection of a kind

To File

You can store your data in CSV, XML, JSON and TXT.

If you do not explicit some parameters when using LLodi DB, To File Defaults will be applied.

Set your default options

Using your LLodi DB

Find out your LLodi DB's URL

{protocol}://{address}:{port}

  • Protocol: If you have added a certificate, HTTPS, otherwise HTTP.

  • Address: localhost or the address to the server where you installed it.

  • Port: . If you are making a remote call, make sure the port is open in your firewall.