Docs
  • LogicLoop Documentation
  • LogicLoop Quickstart
  • Data Sources
    • Connect your data source
      • Deployment options
    • Supported data sources
      • API data (JSON)
      • AWS CloudWatch
      • BigQuery
      • Databricks
      • Google Analytics
      • Google Sheets
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Snowflake
      • Combine Results
      • LogicLoop Data Source
  • Queries
    • Write a rule
      • More rule options
      • A/B testing rules
      • Version history
      • Query Snippets
    • Visualizations & dashboards
      • Visualizations
      • Dashboards
  • Actions
    • Set up an action
    • Action destinations
      • Email
      • Slack
      • Webhooks & APIs
      • Microsoft Teams
      • Salesforce
      • Zapier
      • PagerDuty
      • Write to Database
      • Chain Rules
      • Google Sheets
      • Bento
    • Templating
  • Case Management
    • Case Management
      • Ticket Generation
      • Case Triage
      • Custom Fields and Attachments
  • AI
    • AI Query Helper
    • Ask AI
  • Teams & Settings
    • Integrations
      • Slack
      • Google Sheets
    • Invite your teammate
    • Groups & Permissions
  • Changelog
  • FAQs
  • Troubleshooting
  • Templates
    • Templates Home
    • Risk & Fraud Rules
    • AML Transaction Monitoring Rules
    • Logistics & Marketplace Ops
    • Customer Success & Growth
    • Systems Observability
    • Data Quality Monitoring
    • Healthcare
    • HTML Email Templates
      • Annual Review
      • Weekly Performance Table
      • Invoice Recap
  • BETA
    • AI SQL API
    • Approving rules
    • Render Data as JSON
    • Case Analytics
    • Python
  • Security & Legal
    • Security
    • AI Security
    • Terms of use
    • Privacy policy
    • Services description
Powered by GitBook
On this page
  • Prerequisites
  • Setup
  • Connection Details
  • Additional Settings

Was this helpful?

  1. Data Sources
  2. Supported data sources

Microsoft SQL Server

PreviousMongoDBNextMySQL

Last updated 1 year ago

Was this helpful?

This documentation will guide you through the process of connecting to a Microsoft SQL Server database. To establish a successful connection, you will need to provide specific connection details and, if necessary, configure additional settings.

Prerequisites

Setup

Connection Details

Data Source Name

The "Data Source Name" is a user-defined name for your database connection. You can use any name you prefer to help you identify this connection within your system.

Server

The "Server" is the address or hostname of the Microsoft SQL Server you want to connect to.

Port

The "Port" specifies the port number for the SQL Server instance. The default port for SQL Server is 1433.

User

The "User" is the username you use to authenticate with the SQL Server.

Password

The "Password" is the corresponding password for the user specified above.

Database Name

The "Database Name" is the name of the SQL Server database you want to connect to. Ensure that you have the appropriate permissions to access this database.

Character Set (Optional)

The "Character Set" option is optional and allows you to specify the character encoding for your database connection. The default character set is UTF-8. You can change this setting if your database requires a different character set.

Additional Settings

Use SSL (Optional)

You have the option to use SSL for secure communication with the SQL Server. By default, this option is unchecked. If you wish to enable SSL, you can check the "Use SSL" checkbox.

Verify SSL Certificate (Optional)

By default, the "Verify SSL Certificate" option is checked. This means that the SSL certificate presented by the SQL Server will be verified for authenticity. If you want to bypass SSL certificate verification, you can uncheck this option. However, it's advisable to keep SSL certificate verification enabled for security reasons.

allows access to LogicLoop
Deployment
admin