Configuring for Microsoft SQL Server database services on Azure Cloud
Sterling B2B Integrator v6.2 and above 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.
Note: While creating the database under the Azure Managed instance, make sure to use the collation setting as
SQL_Latin1_General_CP850_BIN.Connection Parameters for the Azure Managed Instance Database
The following table provides connection parameters for the Azure Managed Instance database.
| Parameter | Description |
| DB Vendor | Must be MSSQL |
| DB Host | Azure Managed Instance public or private end point. Example (public end point): |
| DB Port | 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. |
| DB Data | The name of the database schema created under the managed instance. |
| DB User | DB admin user configured for the managed instance database in the Azure portal while creating the managed instance. |
| DB Password | Password for the DB admin user created for the managed instance database in the Azure portal while creating the managed instance. |
| DB Drivers | Use the latest MSSQL JDBC JRE8 based driver. |
| 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 |
| DB Vendor | Must be MSSQL |
| DB Host | Azure SQL Server hosting the Azure SQL DB Example:<azure_sql_server_name>.database.windows.net |
| DB Port | The port on which SQL Server is listening for connections. The default port is 1433 for connections. |
| DB Data | The name of the SQL database created under the SQL server. |
| DB User | DB admin user configured for the SQL database in the Azure portal while creating the SQL server. |
| DB Password | Password for the DB admin user created for the SQL database in the Azure portal while creating the SQL server. |
| DB Drivers | Use the latest MSSQL JDBC JRE8 based driver. |
| Trust Server Certificate | Select True |
| TLS Version |
Use the TLS version configured while creating the Azure SQL. |
Upgrading to Sterling B2B Integrator v6.2 or above from older versions
You can upgrade Sterling B2B Integrator to version 6.2 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.
- 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.
- Choose a different file system than the current version installation when upgrading Sterling B2B Integrator.
- Select the install option and point to the Azure SQL Managed instance or Azure SQL DB in the database connection parameters.
- Select Upgrade as true and run a pre-upgrade check.
- Proceed with the installation, and Sterling B2B Integrator v6.2 will be upgraded with a database hosted in Azure.