Azure SQL Database

Azure SQL Database, Microsoft's cloud-based relational database service, provides organizations with a scalable and fully managed solution for storing, querying, and managing structured data in the cloud. Offering seamless integration with Azure services, comprehensive T-SQL support, and automatic backups, Azure SQL Database is designed to meet the demands of modern applications, enabling developers and administrators to focus on building and optimizing their systems without the overhead of infrastructure management.

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

  • Server
    The URL of the database server, as exposed by Azure.
Omni Loader supports the following authentication schemes:
  • SQL Server
    This is the standard username/password combination stored in and verified by the SQL Server.
  • AAD password
    This is Azure Active Directory password authentication.
  • AAD multi-factor
    Azure Active Directory multi-factor authentication will show a pop-up authenticating you as a separate step.
  • AAD integrated
    Azure Active Directory integrated authentication is an equivalent of what was used to be called Windows authentication for SQL Server.
  • SQL Server
    Connect securely through a Windows user account for authenticated access to SQL Server resources.

  • AAD Managed Identity
    Connect to resources using Azure Active Directory (AAD) Managed Identity or by specifying a user identity for authentication.

  • AAD Password
    Authenticate through an Azure Active Directory (AAD) user name and password.

  • AD Integrated
    Establish a connection through a federated Windows user account.

  • AAD Interactive
    Connect via an interactive authentication flow, using multi-factor authentication for heightened security and user-friendly authentication.

  • Database name
    Click on Select to pick a database from the list of all databases available on the server, or type in by hand.
  • Include views as tables
    If checked, this will list all of the database views as if they were tables in the project and allow for data copying from said views and create the tables on the target.
Data handling defines the way Omni Loader will generate the files and clean up:
  • Clear before run
    Everything in the container folder will be deleted before the data copying starts.
  • Clear after run
    Everything in the container folder will be deleted after the data copying completes.
  • Timestamped
    Nothing is deleted. On each run, Omni Loader creates a new folder named as the current time, then place the files inside the folder. This allows for a complete history, but may generate a large amount of data after many runs.
We support three modes of storage authentication:
  • Connection string
    This is the least secure mode which should not be used in production. It requires account key and grants full access to the whole storage account.
  • Managed identity
    A secure authentication mode, leveraging AAD to grant access to the resource.
  • Shared access signature
    A good middle-ground where one can easily grant access to either a whole account or a specific container only.