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 CLIENT and SERVER components work in Windows, Linux and Mac OS
Linkar currently supports Client libraries for these platforms:
Linkar SERVER currently supports these MVDBMS platforms:
|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 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 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:
The Schema code must be the same of the database file name and MUST exist in the account.
Properties enlarge the file atribute definition. With them you can use the file in other no mv environments.
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:
Linkar CLIENT components are available for use with different programming languages and environments:
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)|
|LinkarClientC.dll / LinkarClientC.lib||C Libraries for Windows|
|libLinkarClientC.so / libLinkarClientC.a||C Libraries for Linux|
Linkar has four types of 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.
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.
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:
They are executed in the same thread of the main application, so they block the execution of the application until they finish.
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.
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.
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.
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.
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.
With your data in PowerBI it is your chance to use this Microsoft power tool.
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?
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.
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.
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.
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.
Discover the Linkar manual to get the most out of its products and functionalities.Show Manual