Strategy One
Microsoft SQL Server
Strategy has been integrating with SQL Server for over 20 years. Strategy supports SQL Server 2022 to SQL Server 2014. The support is downward compatible meaning an older version of SQL Server is also compatible with Strategy One products. Strategy certifies SQL Server as warehouse and repository for Enterprise Manager, History List, Metadata, Narrowcast, and Statistics. SQL Server is not currently supported for Identity Server or Platform Analytics.
Strategy supports Standard (username/password), OAuth, Entra ID, and Kerberos authentication modes to connect to SQL Server. Warehouse pass-through authentication is also supported.
Delegation UID, Integrated, and external browser authentication modes are not supported.
Certified Driver
See the following table that outlines which systems support
| System | SQL Server Progress ODBC | SQL Server Progress JDBC |
|---|---|---|
| Linux - Server |
Y |
Y |
|
Strategy Cloud for Government |
N |
Y |
| CMC | Y | Y |
|
MCE Service |
Y |
Y |
|
Windows - Server |
Y |
Y |
| Windows - Workstation | Y | Y |
Support Authentication Method
| Driver | Standard | OAuth (Starting in SQL Server 2022) | Entra ID (Starting in SQL Server 2022) | Kerberos | NTLM |
|---|---|---|---|---|---|
| Progress ODBC |
Y |
Y | Y | Y | N |
|
Progress JDBC |
Y |
Y |
Y |
N |
Y |
OAuth IdP
Strategy supports Entra ID and Generic OAuth IdP.
Feature Support
| Feature | TLS Connection | Parameterized Query | Unified Quoting | Timezone |
|---|---|---|---|---|
| Support Status |
Y |
Y |
Y |
Y |