SRS Link

Connection node is optional, by default SRS inherit connection from current application.

Connection in SRS are stored in plain text. For security reasons It's recommended to use Paanda Connections Manager. Connections stored in connection manager are secured and are not stored in plain text.

Attributes

name Name of the connection
type ( DEFAULT mssql ) connection type

Connection types

Connection Types

mssql Microsoft SQL Server, Azure SQL DB, Amazon RDS
self Virtual connection to command result
file_system Local/Remote File System (DATA CENTER AND SERVER VERSIONS ONLY)
MsExcel EXCEL ( .xlsx ) files as a database (DATA CENTER AND SERVER VERSIONS ONLY)
srs - srs system connection

Providers documentation

`mssql` provider

Standard SQL Server provider connect to Microsoft® SQL Server | Microsoft® Azure SQL | Amazon RDS for SQL server.

`file_system` provider (alpha)

System can query file system like SQL database.

Parameters:

Path (required)
Server (optional) remote server
User(optional) remote server user
Password (optional) remote server password
SearchPattern=. (optional, default = .)
SubDirectories=true (optional, default = false)

XML
<srs>
  <def>
      <!--Abolute path-->
      <itm model="dsn" name="dropbox" type="files">Server=myServer;Path="c:\git\platforma-docs" SearchPattern=*.*; SubDirectories=true</itm>
      <!--Sample with relative path to data folder-->
      <itm model="dsn" name="dropbox" type="FileSystem">Server=myServer;Path="\test1";SearchPattern=*.*; SubDirectories=true</itm>
  </def>
</srs>

Available fields

CreationTime text,
CreationTimeUtc text,
DirectoryName text,
Name text,
Length Numeric,
FullName text,
Extension text,
Content text, (read only ".html" ,".md", ".txt", ".sql", ".xml", ".json")
Slug text

`excel` provider

Parameters:

Path (required)
Server (optional) remote server
User(optional) remote server
Password (optional) remote server
Header (optional) true/false

XML
<srs title="Price list">
    <def>
        <itm model="dsn" name="excel" type="MsExcel">Path="pricelist.xlsx";Header=True</itm>    
      <itm model="command" name="dropbox" dsn="excel"></itm>
  </def>
</srs>