DSN

The Data Source node is optional. By default, SRS inherits the connection from the current application.

Connections in xml file are stored in plain text. For security reasons, it is recommended to use the jetQuery Connections Manager. Connections stored in the connection manager are secured and encrypted.

Attributes

• name: Name of the connection.
• type (default: mssql): Connection type.
  • mssql: Microsoft SQL Server, Azure SQL DB, Amazon RDS
  • self: Virtual connection to command result
  • (experimental) file_system: Local/Remote File System
  • (experimental) MsExcel: EXCEL (.xlsx) files as a database
  • srs: SRS system connection
• text: Connection string

Types

mssql - SQL Server Provider

The standard SQL Server provider connects to Microsoft® SQL Server, Microsoft® Azure SQL, and Amazon RDS for SQL Server.

file_system - File System Provider

The system can query the file system like a 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)

<srs>
  <def>
      <!-- Absolute 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 for .html, .md, .txt, .sql, .xml, .json)
• Slug (text)

excel Provider

Parameters:

• Path (required)
• Server (optional): Remote server
• User (optional): Remote server user
• Password (optional): Remote server password
• Header (optional): true/false

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