BusinessInsight Agent - Sample Database Connection Strings
=========================================================

Use this file as a reference when editing the connection string inside a downloaded customer Agent launcher.

Recommended path:
1. Extract BusinessInsight-Agent-Package.zip.
2. Copy the company-specific Start-<tenant>-Agent.cmd launcher into the same folder.
3. Open the copied launcher in a text editor.
4. Find the Agent__TenantConnections__<tenant>__ConnectionString line.
5. Replace server, database, username, and password placeholders with the local client database values.
6. Save the launcher and start it from the Agent folder.

Important:
- New trial launchers use one plain connection string in the launcher file.
- Keep one client database connection string in one Agent folder.
- Use a separate Agent folder and launcher for another tenant or client database.
- Use a read-only database login whenever username/password is required.

Supported Provider Names
------------------------
SqlServer
PostgreSql
MySql
Oracle
Sqlite
Odbc

SQL Server / MSSQL
------------------
Windows sign-in:
Server=YOUR-SERVER;Database=YOUR-DATABASE;Integrated Security=true;TrustServerCertificate=true;Encrypt=false;Application Name=BusinessInsight.Agent

SQL login:
Server=YOUR-SERVER;Database=YOUR-DATABASE;User ID=readonly_user;Password=YOUR_PASSWORD;TrustServerCertificate=true;Encrypt=false;Application Name=BusinessInsight.Agent

Local SQL Express example:
Server=.\SQLEXPRESS;Database=ClientReportingDb;Integrated Security=true;TrustServerCertificate=true;Encrypt=false;Application Name=BusinessInsight.Agent

PostgreSQL
----------
Host=localhost;Port=5432;Database=client_db;Username=readonly_user;Password=YOUR_PASSWORD;Application Name=BusinessInsight.Agent

With SSL preferred:
Host=db.example.com;Port=5432;Database=client_db;Username=readonly_user;Password=YOUR_PASSWORD;SSL Mode=Prefer;Trust Server Certificate=true;Application Name=BusinessInsight.Agent

MySQL / MariaDB
---------------
Server=localhost;Port=3306;Database=client_db;User ID=readonly_user;Password=YOUR_PASSWORD;SslMode=Preferred;Application Name=BusinessInsight.Agent

Remote server:
Server=db.example.com;Port=3306;Database=client_db;User ID=readonly_user;Password=YOUR_PASSWORD;SslMode=Required;Application Name=BusinessInsight.Agent

Oracle
------
Service name:
User Id=readonly_user;Password=YOUR_PASSWORD;Data Source=host:1521/service

TNS alias:
User Id=readonly_user;Password=YOUR_PASSWORD;Data Source=ORCLPDB1

SQLite
------
Data Source=C:\Data\client.db;Mode=ReadOnly

Data Source=C:\Data\client.sqlite;Mode=ReadOnly

ODBC
----
Existing Windows ODBC DSN:
DSN=ClientReportingData

DSN with credentials:
DSN=ClientReportingData;Uid=readonly_user;Pwd=YOUR_PASSWORD

Microsoft Access via ODBC driver:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\Data\client.accdb;ReadOnly=1

Excel via ODBC driver:
Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=C:\Data\reporting.xlsx;ReadOnly=1

FoxPro DBF folder via ODBC driver:
Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=C:\Data\FoxPro;Exclusive=No;ReadOnly=Yes

Manual appsettings.json example for testing only
-----------------------------------------------
This is plain text. For customer machines, prefer editing the downloaded Start-<tenant>-Agent.cmd launcher instead.

{
  "Agent": {
    "TenantConnections": {
      "YOUR_TENANT_ID": {
        "Provider": "SqlServer",
        "DataSource": "YOUR-SERVER",
        "DatabaseName": "YOUR-DATABASE",
        "ConnectionString": "Server=YOUR-SERVER;Database=YOUR-DATABASE;Integrated Security=true;TrustServerCertificate=true;Encrypt=false;Application Name=BusinessInsight.Agent",
        "IntegratedSecurity": true
      }
    }
  }
}

Manual PowerShell launch examples
---------------------------------
SQL Server:
.\Start-BusinessInsight-Agent.ps1 -TenantId "YOUR_TENANT_ID" -AgentId "agent-YOUR_TENANT_ID" -Provider "SqlServer" -ConnectionString "Server=YOUR-SERVER;Database=YOUR-DATABASE;Integrated Security=true;TrustServerCertificate=true;Encrypt=false;Application Name=BusinessInsight.Agent"

PostgreSQL:
.\Start-BusinessInsight-Agent.ps1 -TenantId "YOUR_TENANT_ID" -AgentId "agent-YOUR_TENANT_ID" -Provider "PostgreSql" -ConnectionString "Host=localhost;Port=5432;Database=client_db;Username=readonly_user;Password=YOUR_PASSWORD;Application Name=BusinessInsight.Agent"

MySQL:
.\Start-BusinessInsight-Agent.ps1 -TenantId "YOUR_TENANT_ID" -AgentId "agent-YOUR_TENANT_ID" -Provider "MySql" -ConnectionString "Server=localhost;Port=3306;Database=client_db;User ID=readonly_user;Password=YOUR_PASSWORD;SslMode=Preferred;Application Name=BusinessInsight.Agent"

Oracle:
.\Start-BusinessInsight-Agent.ps1 -TenantId "YOUR_TENANT_ID" -AgentId "agent-YOUR_TENANT_ID" -Provider "Oracle" -ConnectionString "User Id=readonly_user;Password=YOUR_PASSWORD;Data Source=host:1521/service"

SQLite:
.\Start-BusinessInsight-Agent.ps1 -TenantId "YOUR_TENANT_ID" -AgentId "agent-YOUR_TENANT_ID" -Provider "Sqlite" -ConnectionString "Data Source=C:\Data\client.db;Mode=ReadOnly"

ODBC:
.\Start-BusinessInsight-Agent.ps1 -TenantId "YOUR_TENANT_ID" -AgentId "agent-YOUR_TENANT_ID" -Provider "Odbc" -ConnectionString "DSN=ClientReportingData"