• linkar wall
    Linkar Family
    Linkar SOLUTIONS
    Connect with your MultiValue Databases easily and efficiently.
    Centralize the connections and share the same lines to optimize them.
    Develop your applications without thinking about the Database. Linkar does it for you.
  • linkar-wall
    Linkar-PBI
    LINKAR POWER BI PLUGIN
    Creates a straight connection between Microsoft PowerBi and your PICK MULTIVALUE database.
    Without web services, without any other program requirement.
    LINKAR does it for you.

Linkar Suite

Linkar is a suite of components that facilitates efficient connectivity to MultiValue Databases

Linkar SERVER works with many MultiValue Database platforms, centralizing connections and optimizing DBMS license usage.

Client apps use Linkar CLIENT libraries, with bindings for popular languages, to interact with the database through Linkar SERVER.

Summary: With the Linkar suite of components, client-side interfaces are written with a variety of programming languages, to connect to a variety of MV servers.

linkar schema


Linkar CLIENT and SERVER components work in Windows, Linux and Mac OS

Windows
Linux
Mac OSX


Linkar currently supports Client libraries for these platforms:

Clients


Linkar SERVER currently supports these MVDBMS platforms:

OpenQM
D3
Universe
Unidata
jBASE
Linkar Server

Linkar SERVER is responsible for managing communications with MultiValue databases. It is a sophisticated socket server that listens for Client requests. Accessing the database through Linkar SERVER has these advantages compared to direct access from a client application:

  • Client applications through Linkar do not need an exclusive database license. Different clients can share a single Database license with session pooling to maximize license efficiency.
  • Client applications don't need to manage connections with databases. Linkar SERVER will open connections on demand, as required. Linkar SERVER also will close the open connections when they are no longer necessary.
  • The client applications are independently designed from the MultiValue Database type that it will use.

The following connection types are available:

Database O.S. where LinkarServer is installed Connection Type Recommended Other Connection Types
OpenQM Windows / Linux / Mac OS Windows / Linux / Mac OS QMCLIENT SOCKET
D3 Windows / Linux Windows / Linux / Mac OS SOCKET
UniVerse Windows / Linux Windows UNIOBJECTS SOCKET
UniVerse Windows / Linux Linux / Mac OS SOCKET
UniData Windows / Linux Windows UNIOBJECTS SOCKET
UniData Linux Linux / Mac OS SOCKET
jBASE Windows / Linux Windows jAGENT
Linkar Manager

Linkar MANAGER is the Linkar SERVER configuration and monitoring utility. Visually configure entry points to different databases, indicate the number of sessions that you want to use, and how to open sessions. Sessions can be opened permanently at the start of the service, or on demand when conditions require more sessions to handle customer requests. Linkar MANAGER also allows monitoring and management of active sessions.

Linkar Manager Screen
Linkar Schemas

Linkar Schemas allows you to enlarge file definitions and dictionaries with a set of properties taht you can use later in different environments or platforms like .Net, Java, etc

Likewise, you can map the mv database closer to the relational world. Multivalues and Subvalues will be seen as Relational Tables (different tables with all relations between them automatically built for you.

Each EntryPoint has its defined Schemas and all of them are saved in the EntryPoint Data Account.

Linkar Schemas does not change your dictionaries nor create new ones. All Schemas data are saved in Linkar Files in your data account.

Linkar Schemas has three components:

  • Schemas: Database file extended definitions.
  • Properties: Database file properties for file atributes.
  • EntryPoint Parameters: EntryPoint exclusive Schemas parameters.
  • The Schema code must be the same of the database file name and MUST exist in the account.

welcome

Properties enlarge the file atribute definition. With them you can use the file in other no mv environments.

welcome
Linkar Client

Linkar CLIENT libraries are used to create client interfaces to servers. Programmers use a variety of functions to request and receive data, and to execute programs in database applications. Using Linkar CLIENT libraries has these advantages compared other connectivity options:

  • For security and other reason, the client app does not interact directly with the database. The application communicates with Linkar SERVER, and Linkar SERVER interacts with databases
  • Your applications do not need different libraries, depending on the MV databases being used. One set of client code will support multiple MV server types
  • There are several Linkar CLIENT language bindings, allowing developers to use consistent client-side development patterns to access servers

Linkar CLIENT components are available for use with different programming languages and environments:

  • NET (C#, Visual Basic, F#,...) for Windows x64 and x86 environments.
  • NET Core for multi-platform development (Linux, Mac,...).
  • MONO for multi-platform development (Linux, Mac,...).
  • Java (all OS types).
  • All languages and environments which can use C Libraries, such as PHP, Python and NodeJS
  • COM-compliant languages like Excel VBA and PHP.
  • A console application, in order to make operations from, for example a command script from the OS.
  • From BASIC to another remote Database, regardless of which is it.

Linkar comes with a console application, embedding Linkar CLIENT, to perform operations from the OS command-line and scripts. For example, you can write a .bat file or shell script that sends and retrieves data to/from the MV server for any purpose.

Linkar also includes an MV-side client to reach out to other MV servers to read, write, or execute with a remote system, even a different MVDBMS type.

This example shows how to create a simple application in C#.

Linkar Libraries and Platforms from where they can be used:

LinkarClient.dll .NET Framework Client
LinkarClientCOM.dll Languages compatible with COM (PHP, MS Office VBA, ...)
LinkarClientCore.dll .NET Core Client (Windows, Linux, Mac)
LinkarClientMono.dll Mono Framework Client (Windows, Linux, Mac)
LinkarClient.jar Java Client
LinkarClientC.dll / LinkarClientC.lib C Libraries for Windows
libLinkarClientC.so / libLinkarClientC.a C Libraries for Linux

Linkar has four types of Functions:

PERSISTENT FUNCTIONS

Are exclusive of the OOP (OBJECT-ORIENTED PROGRAMMING) and allow the creation of a LinkarClt object that manages all the operations.

After creating the object it is necessary to make a Login that through a Session code allows making all the wished operations until a call to the Close method is produced or until the session expires because of inactivity, defined on its EntryPoint.

They are useful for applications that require user identification, for instance to log into an ERP session.

DIRECT FUNCTIONS

Used for the direct and independent communication with the Database. Its arguments contain the necessary information to identify the user before returning the required information. Unlike the Persistent Functions these don't have Session Code, each call is completely independent from the others and do not have Login or Close functions.

They are used for Database access from public webpages, for instance online shops.

TEXT FUNCTIONS

These type of function doesn’t need to access the Database. They are executed in the client and its goal is to ease the management of the MV buffers.

C AUXILIARY FUNCTIONS

Are C libraries exclusive

They are executed in the client and its goal is to allow an easier management of other complex C functions.

There are no classes in C, nor objects also, these functions are used to create encoded strings that emulate other languages.

On the other hand, Linkar supplies other types of calls:

SYNCHRONOUS CALLS

They are executed in the same thread of the main application, so they block the execution of the application until they finish.

ASYNCHRONOUS CALLS

They are executed in a different thread, so they don't block the execution of the application. When the call is made a return method is required (Callback) which triggers when finished the operation.

Linkar Tester

Verify the database configurations and may help you to familiarize with how to connect and work with Linkar SERVER from client applications. It allows you to test the library functions in a graphic way through an application. Just like the times measuring and the commands execution. It's not and end user application. It's function is educational allowing you to explore all the options and possibilities of the Linkar SERVER library functions.

lksendcommand.exe

This commands line executable provides an easy way of executing the SendCommand function from different environments. For example, from a Windows bat file or from a Basic Program to access to the data from other remote Databases.

lksendcommand
Linkar PowerBI

CREATES A STRAIGHT CONNECTION BETWEEN MICROSOFT POWERBI AND YOUR PICK MULTIVALUE DATABASE.

WITHOUT WEB SERVICES WEB SERVICES, WITHOUT ANY OTHER PROGRAM REQUIREMENT.

LINKAR DOES IT FOR YOUR.

Linkar PoweBI Connector is a Linkar plugin that allows you to give visibility to your PICK Multivalue database from PowerBI.

You can make a direct connection from PowerBI to your PICK / Multivalue database. You do not need to create and publish any webservice, you do not need a web server and you do need to write any DataBasic program also.

The Linkar PowerBI connector Works like any other data source, for instance to SQL Server. In addition, Linkar PowerBI knows how to work with your multivalues and subvalues. All the PowerBi power in your hands.

Using Linkar Schemas you will see your PICK MUltivalue files as Relational Tables, and Linkar will convert the Multivalue, Subvalue groups to nested tables with all its relations with the parent table.

Linkar Power Bi Schemas

PowerBI can import all the files you need or execute queries and import only needed data.

Relations defined in Linkar Sechemas will be created automatically. Later you can change them or create more.

Linkar Power Bi Relations


With your data in PowerBI it is your chance to use this Microsoft power tool.

Linkar Power Bi Sample


Linkar PowerBI Connector is a plugin. You can activate it in your Linkar Server. There is no limit. You can use the data of any of the Linkar Server EntryPoints.

What do you need to start?

  • One active Linkar Server PRO license or Evaluation (it does not work with the Lite License).
  • One active LinkarPowerBI Connector License in the Plugins section of your Linkar Server.
  • Use Linkar Schemas to define what files you want to use. It is very easy and there are tools to help you the very first time.
  • The EntryPoint you want to use must be opened.
  • You must install the Linkar PowerBI Client in all the Windows systems you will use with PowerBI. There is no limit in the number of Linkar PowerBI clients.

With the Linkar PowerBI connector license you can deploy all the clients you need.

Linkar PowerBI Connector does not work with Linkar Lite version. If you want to test it, you can apply for an Evaluation License.



Licenses and Prices


LITE


This is a free License and does not require any activation, registry ,etc. in order to work.


The limit for the LITE license is that it only can maintain one session with the Linkar SERVER and the database simultaneously.


Multiple configurations are allowed (EntryPoints) with Databases, but only one of them will be operational each time.


Only one Linkar CLIENT can connect with Linkar SERVER and access to the Database each time.


When one client logs out, another client will be able to log in.




PRO


This is the Linkar commercial licence. It can be purchased in the KOSDAY webpage or by email. You will have to provide some data in order to register the Licence. Check the License Data section in the Linkar Manager Configuration.


This license can be registered by number of sessions or by Database lines. You will be able to define in each EntryPoint all sessions or Database lines you need. More Database lines defined in an EntryPoint gives the system more capacity to process concurrent operations, so Linkar SERVER performance will be better and Linkar CLIENTS faster.


The sum of all opened sessions won't be bigger than the purchased sessions number.


Regarding to the number of simultaneous Linkar CLIENTS, there is not any kind of limitation.


PRO License allow can update with new versions during the subscription life.


Linkar Prices

LITE

per session

FREE

  • 1
  • 1

PRO

por sesión

$58.00

  • According to Purchase
  • Unlimited
  • With Subsctiption
  • With Subsctiption

Suscription

per year and session

$14.00



Linkar PowerBI Connector Prices

PRO

por sesión

$500.00

  • Unlimited
  • With Subsctiption
  • With Subsctiption

Suscription

per year and session

$75.00



RETURN GUARANTEE

During the first 30 days from the date of purchase, if you have technical problems or errors that prevent you from using the product on your computer, contact our support. We will do our best to solve the problem. If we do not get it, and you can not make it work, we'll give you back the money.

BUY NOW
download

DOWNLOADS

Download the latest version of Linkar and discover all its advantages.

Download
help

HELP

Discover the Linkar manual to get the most out of its products and functionalities.

Show Manual
how to

HOW TO

Some programming examples using Linkar Client                

Show examples
blog

BLOG

The Blog has Post that will surely help you

Go to Blog
forum

FORUM

In the Forum we give continuous support to all your doubts and problems

Go to Forum
faq

FAQ

In our FAQ you will find a solution to the most common questions about Linkar and other products.

Show FAQ