The OneCloud Microsoft SQL Server BizApp enables OneCloud to integrate with the Microsoft SQL Server relational database natively. Combining the ability to perform relational operations across other applications, including Workday, NetSuite, SAP, and performance management applications such as Anaplan, IBM Planning Analytics, Planful, and Oracle EPM allows OneCloud customers to tightly and bi-directionally integrate their relational systems with other applications.

📓 Support for Microsoft Azure SQL Database

This BizApp fully supports bi-directional integration with Microsoft Azure SQL Database.

Connection Setup

To enable OneCloud to interact with a relational system, navigate to the Connection manager to create a Connection. From here, choose Microsoft SQL Server from the service drop-down, select the appropriate Runner, and use the Microsoft SQL Server Connection Parameters to complete the setup.

SQL Server Port

The default Microsoft SQL port is 1433, but it could be different depending on your environment.

SQL Server Connection Parameters

Visit Microsoft's SQL Server documentation to learn more about additional Connection parameters that can be leveraged. Some typical connection parameters include:

  • Preset database name: databaseName

  • domain: Fully qualified domain of the Active Directory server

  • authenticationScheme=NTLM

  • integratedSecurity=true

Here is a sample Connection string to connect only to the data_hub database and use Active Directory-integrated security:

jdbc:sqlserver://localhost:1433;databaseName=data_hub;domain=ad.acme.net;
authenticationScheme=NTLM;integratedSecurity=true;

Connection Example

Please substitute your own values.

⚠️ This BizApp requires the installation of a Java runtime. For best system compatibility please install Java 8.

💡 Remember to activate the Connection for the desired Environments.

Did this answer your question?