SQL execution
Run SELECT, INSERT, update, or other approved SQL statements as part of a workflow.
MS SQL Database component
MS SQL Database for customer-owned automation.
Use MS SQL Database when workflow automation needs to read or write SQL Server data inside the customer environment.
Query and update Microsoft SQL Server data from controlled integration flows.
MS SQL Database
Component
MS SQL DatabaseUse stored database credentials, test connectivity, run SQL, and inspect output.
CX
CXFabric Flow
Rules, credentials, validation, audit
SettingsInputs and options
LogsRun history and output
Next stepConnector, component, or approval
What this component unlocks
Use MS SQL Database as a visible flow step.
The docs describe the Microsoft SQL Database component as supporting SQL statements, query testing, connection testing, and JSON or table output views. Builders select stored database credentials, manage credentials, and use Test Connection before running SQL. The SQL editor can be resized vertically, Test Query runs valid SQL from the editor, and output can be reviewed as JSON or a table with clear success or error feedback.
Connection testing
Verify credential and network access before saving or executing a database step.
Readable output
Review query results as JSON or a table while configuring the component.
Use cases
Where MS SQL Database fits in automation.
These examples show how this component can become part of production workflows across customer-owned systems and environments.
Customer record lookup
Use MS SQL Database as part of a governed CXFabric workflow that keeps configuration, credentials, logs, and handoffs visible.
- Collect the approved input
- Apply customer-specific rules
- Pass a clear result to the next step
Back-office update
Use MS SQL Database as part of a governed CXFabric workflow that keeps configuration, credentials, logs, and handoffs visible.
- Collect the approved input
- Apply customer-specific rules
- Pass a clear result to the next step
Operational report
Use MS SQL Database as part of a governed CXFabric workflow that keeps configuration, credentials, logs, and handoffs visible.
- Collect the approved input
- Apply customer-specific rules
- Pass a clear result to the next step
Data validation
Use MS SQL Database as part of a governed CXFabric workflow that keeps configuration, credentials, logs, and handoffs visible.
- Collect the approved input
- Apply customer-specific rules
- Pass a clear result to the next step
Legacy database sync
Use MS SQL Database as part of a governed CXFabric workflow that keeps configuration, credentials, logs, and handoffs visible.
- Collect the approved input
- Apply customer-specific rules
- Pass a clear result to the next step
Audit enrichment
Use MS SQL Database as part of a governed CXFabric workflow that keeps configuration, credentials, logs, and handoffs visible.
- Collect the approved input
- Apply customer-specific rules
- Pass a clear result to the next step
Configuration surface
Practical options builders expect to use.
The exact fields can vary by deployment and product version, but each page gives customers a clear view of the component's intended role.
Add MS SQL Database to canvas
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Select database credential
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Test connection
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Enter SQL statement
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Test query
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Review JSON or table output
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Submit settings
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Execute and review logs
Expose this behavior as a reusable, logged, credential-aware step inside a CXFabric flow.
Implementation notes
Design the step with operations in mind.
Components should be easy for builders to configure and easy for operators to understand after the workflow is live.
Current CXFabric docs
Use Test Connection before query execution
Use Test Connection before query execution.
CXFabric approachMake the behavior explicit in the workflow so operators can see what happens before and after this component runs.
Review query errors carefully
Review query errors carefully.
CXFabric approachMake the behavior explicit in the workflow so operators can see what happens before and after this component runs.
Use least-privilege credentials and avoid unbounded production queries
Use least-privilege credentials and avoid unbounded production queries.
CXFabric approachMake the behavior explicit in the workflow so operators can see what happens before and after this component runs.
Workflow patterns
Reusable patterns for MS SQL Database.
These are concept patterns that can be adapted to a customer's systems, policies, credentials, and deployment model.
MS SQL Database in a customer intake flow
Start with an event, use MS SQL Database, then route the result to CRM, ticketing, or a customer-owned system.
MS SQL Database with approval and audit
Add validation, human approval, and logging around the component before downstream actions execute.
MS SQL Database in a private runtime
Deploy the component inside a customer-owned environment with credentials and logs governed by the customer.
MS SQL Database plus custom connector
Combine the component with packaged connectors or custom APIs when the process needs reusable system logic.
Component planning
Need MS SQL Database inside a customer workflow?
We can scope the workflow, component configuration, credentials, deployment model, and handoff path before buildout begins.