Send data to your own database from Qlik.
Store your data into files (plain text, csv, json, xml...)
For the moment it is required to contact with LLodi Support to get and install your LLodi DB instance.
LLodi Agent supports both HTTP (by default, port 8098) and HTTPS (by default, port 8099).
You can modify the ports in your configuration tab.
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".
To add an additional layer of security you can require a LLodi Key to be added to any request to your DB service.
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.
LIB CONNECT TO 'LLodi Writer Connector';SELECTFROM [DB update]WITH GUID 123l4567-8l9o-0d1i-2a3l-456l7890od1iWITH FIELDS ("user" "Jhon","id" "44","email" "firstname.lastname@example.org","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");
When enabled Whitelist feature will accept only IPs or domains on the list, blocking all others.
You can connect different databases to your LLodi DB. MySQL, Oracle and SQL Server are supported, but other types will be available soon.
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 store your data in CSV, XML, JSON and TXT.
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.