Introduction Macrobond SQL Database connector configuration file includes a section specifying data provider database connection string and connection string. It’s unique to each database type. This page includes examples for most commonly used databases. MySQL and MariaDB Please install https://dev.mysql.com/downloads/connector/net/ and use: <sql:DataProvider> <sql:Name>MySql.Data.MySqlClient</sql:Name> <sql:ConnectionString> Server=address.of.the.server; Database=dbname; Uid=user;Pwd=pass;​ </sql:ConnectionString> <!– instead of Uid=user;Pwd=pass;​ you can use … Continue reading “SQL In-house – connection strings”

Introduction Requirements How to connect? Accessing data Introduction You can test our SQL database connector functionality with three views of test SQL database. Requirements Our example utilizes the MySQL and requires .NET connector for MySQL. This will allow Macrobond to ‘talk’ to SQL database. You will also need xml path file which you will receive … Continue reading “SQL demo Virtual Machine”

Sample configurations for the Macrobond SQL database provider Metadata organization Metadata organized in multiple columns Dynamic tree of varying depth Single Identifiers with special characters Sample configurations for the Macrobond SQL database provider The following sample solutions should be treated as an example or starting point rather than a complete solution. The presented configuration might … Continue reading “SQL In-house – examples”

Introduction Getting started Configuration file DataProvider Series Metadata BrowseTree Trees of varying depth Sample configuration  More examples Troubleshooting Introduction With the Macrobond SQL Database connector you can use the Macrobond Analysis application to read time series from a SQL database. Macrobond Analysis does not store your data located in SQL database. Getting started There is … Continue reading “The Macrobond SQL Database Connector”