Quickstart Guide: Microsoft SQL Server Connector | Freehand Query Object and Task Example

In this video we will demonstrate how to create a Freehand Query in the Business Object Designer and how to use the Connector Tool in a basic BPA Platform Task.

Codeless Platforms’ Microsoft SQL Server Connector removes the need for complex coding or scripting and provides you with instant access to a nominated SQL Server database. It includes data mapping and transformation capabilities, error handling and scheduling options, making it easier for you to build and maintain simple or complex data integrations, streamline workflows and improve data accuracy.

This a simple example of the tool in use, however a typical example in an integration context would include data passed from an Application to the Microsoft SQL Server Connector, mapping and transforming the data, and then passing this to a Staging Database from where it will be sent to the target system, such as an ERP

00:00 Introduction
00:22 Prerequisites
00:45 Business Object Designer - Freehand Query Object
03:40 Microsoft SQL Server Tool Demonstration
07:25 Summary and Contact Details

Thanks for watching this Quickstart Guide: Microsoft SQL Server Connector | Freehand Query Object and Task Example