Skip to content

microsoft-sql-server.md

Latest commit

 

History

History
28 lines (18 loc) · 1.6 KB

microsoft-sql-server.md

File metadata and controls

28 lines (18 loc) · 1.6 KB

Microsoft SQL Server

Microsoft SQL Server is a relational database management system (RDBMS), offering a comprehensive platform for storing, managing, and retrieving data from various sources.

Prerequisites

  • Get Microsoft SQL Server database connection parameters from the database owner.
  • Refer to IP allowlist to add IP addresses of Openblocks to your allowlist (if needed).

Connect to Microsoft SQL Server data source

Follow the steps below:

  1. Create a new data source in two ways. Note that this permission is restricted to workspace admins and developers.

    • Navigate to the Data Sources tab on Openblocks Homepage and click New data source.

    • When creating a new query in the app editor, click + New > + New data source.

  2. Select Database > Microsoft SQL Server as the data source type.

  3. Set its name and configure general settings, including host, port, and database name. You can also set the user name and a password.

  4. (Optional) Click Test connection to check whether the new data source is successfully connected.

  5. Click Save, and it will be saved to your data source library.