PowerServer 2021: Adapting Database Logins
summary
Explains how PowerServer maps database logins using connection caches defined in the Web API dialog and exported to applications.json, demonstrating three concrete options: a static cache mapped to sqlca, a dynamic cache set via dbparm at runtime, and a dynamic connection that passes client credentials through. Shows sample PowerScript code and an installable app, measures the tradeoffs: dynamic connection forces a disconnect/reconnect on every REST call (big performance hit) and exposes client credentials, while cache-based approaches require separate user auth (encrypted user table or third‑party auth) or a mixed login-once strategy.
AI-written summary · about
chapters (14)
- 0:00Introduction and agenda
- 1:48Configuring connection caches
- 5:25Static cache overview
- 7:10Dynamic cache setup
- 10:18Dynamic connection explained
- 12:05Security comparison of options
- 14:14Performance implications
- 16:00User authentication methods
- 21:40Long-term architecture benefits
- 22:43Multi-environment and multi-tenant setups
- 23:47Demo: Static cache
- 26:20Demo: Dynamic cache
- 28:52Demo: Dynamic connection
- 30:21Q&A
related talks
21mReal-Time Connectivity to Snowflake and 100s of Sources from the Power Platform
32mSynapse Serverless SQL Pool: SQL without database
43mPower BI Monitoring 101
21mThe Power of Polybase with SQL - True data Virtualisation
51mThe Microsoft Intelligent Data Platform
01h 15mChoose Azure SQL Database and Learn What Every Developer Should Know
54m10 Deadly Sins of SQL Server Configuration
51mFrom Your Couch to the Cloud: When and Why to Choose the Azure Portal