Configuring Certified Container for MSSQL Server database services on Azure Cloud

Sterling B2B Integrator v6.2 and above Certified Container now supports installation with Azure Managed Instance database and Azure SQL database.

Azure SQL Database is an always-up-to-date, fully managed relational database service built for the cloud. Eliminate the complexity of configuring and managing high availability, tuning, backups, and other database tasks with a fully managed SQL database. For more information, see Azure SQL Database.

Following are the sample connection parameters for the Azure Managed Instance databases. For more information, see Connectivity architecture for Azure SQL Managed Instance.

Connection Parameters for the Azure Managed Instance Database

The following table provides connection parameters for the Azure Managed Instance database.
Parameter Description
dbVendor Must be MSSQL
dbHost Azure Managed Instance public or private end point.

Example (public end point): <mi_name>.public.<dns_zone>.database.windows.net
dbPort The port on which the managed instance is listening for connections. Use port 1433 for private end point and 3342 for public end point connections.
dbData The name of the database schema created under the managed instance.
dbDrivers Use the latest MSSQL JDBC JRE8 based driver.
MSSQL_TRUST_SERVER_CERTIFICATE Select True
TLS_VERSION Use the TLS version configured while creating the Azure SQL managed instance.

Connection Parameters for Azure SQL Database

The following table provides connection parameters for Azure SQL database.
Parameter Description
dbVendor Must be MSSQL
dbHost

Azure SQL Server hosting the Azure SQL DB

Example: <azure_sql_server_name>.database.windows.net
dbPort The port on which SQL Server is listening for connections. The default port is 1433 for connections.
dbData The name of the SQL database created under the SQL server.
dbDrivers Use the latest MSSQL JDBC JRE8 based driver.
MSSQL_TRUST_SERVER_CERTIFICATE Select True
TLS_VERSION

Use the TLS version configured while creating the Azure SQL.

Upgrading to Sterling B2B Integrator Certified containers v6.2.0.0 or above from older versions

You can now upgrade Sterling B2B Integrator certified containers to version v6.2.0.0 with a database hosted on an Azure Managed Instance database or an Azure SQL database. Follow the steps below to upgrade to MSSQL DB on Azure.
  1. Export the database from the in-house MSSQL Server database and migrate to an Azure Managed Instance or Azure SQL Database. For more information, see SQL Server to Azure SQL Database and SQL Server to Azure SQL Managed Instance.
  2. In the values.yaml file, update the dataSetup connection details pointing to the database under the SQL Managed instance or Azure SQL DB.
  3. Select enabled as true and upgrade as true under dataSetup. For more information, see Upgrading the software.
  4. Proceed with the Helm upgrade, and Sterling B2B Integrator v6.2.0.0 will be deployed with a database hosted in Azure.