Notă
Accesul la această pagină necesită autorizare. Puteți încerca să vă conectați sau să modificați directoarele.
Accesul la această pagină necesită autorizare. Puteți încerca să modificați directoarele.
Connect to PICK Style / MultiValue Databases.
Summary
| Property | Value |
|---|---|
| Connector |  Linkar PICK Style / MultiValue Databases |
| Products | Power BI (semantic models) Power Query Online |
| Release state | Preview |
| Category | Database |
| Authentication kinds | Basic |
| Data source kind | Linkar |
| Function Reference Documentation | Linkar.Contents |
| Support link | Support |
Supported capabilities
Entry point: Linkar.Contents
Parameters
Entry point: Linkar.Contents
Required parameter count: 3
| Parameter | Display name | Required | Type | Description | Allowed values | Sample values | Nullable | Declared allowed values |
|---|---|---|---|---|---|---|---|---|
| server | Linkar Host | Yes | text | Linkar Server IP address or DNS | "127.0.0.1"; "localhost" | false | ||
| entrypoint | EntryPoint Name | Yes | text | Data account EntryPoint Name. | "DEMO" | false | ||
| port | EntryPoint Port | Yes | number | Write the EntryPoint TCP Port | 11300 | false | ||
| language | Language | No | nullable text | If you have different languages defined, write the language which you want to visualize the data | "EN" | true | ||
| freetext | Free Text | No | nullable text | Just to identify your session in Linkar Manager | "From Power Bi" | true | ||
| customvars | Custom Variables | No | nullable text | You can write here what you need to perform custom controls | "Your vars.." | true | ||
| FileName | Table Name | No | nullable text | Write the defined Table Name in Linkar Schemas. If you want to use a MV Table or SV Table you must use extended notation: TableName.MVTableName.SVTableName. For example to bring the group of Multivalues called MVItems we must write Orders.MVItems. Remember, all the Tables Names must be defined in Linkar Schemas. | "Orders" | true | ||
| SelectClause | Select Clause | No | nullable text | Use the syntax as a SELECT on the database. You can use Property Names or File Dictionary Names. | "WITH Customer = "84"" | true | ||
| DictClause | Dict Clause | No | nullable text | All Linkar Schemas Properties that are visible, separated by spaces. Only the data will be brought | "Customer Date Item IItemDescription" | true | ||
| SortClause | Sort Clause | No | nullable text | Like SELECT in the database. You can use Property Names or File Dictionary Names. | "BY Customer" | true | ||
| sqlmode | Force SQL Mode | No | nullable logical | If you activate this option data will come in SQL Mode. This mode adapts your data to the style of a SQL table | true; false | true | true | [true, false] |