SQL Server Connector


Automate the process of extracting data from SQL Server and converting it to XML messages, and vice versa.


Download the SQL Server connector below to add it to ArcESB.

Download Connector Documentation
Version: 20.0.7488
07/02/2020

The Benefits of SQL Server

  • Integrate your backend SQL Server directly into your business process workflows.
  • ArcESB can connect to numerous database servers including SQL Server, Oracle, MySQL, MariaDB, DB2, PostgreSQL, and many more using an ODBC, JDBC, or ADO.NET driver.
  • Retrieve records from tables using an intuitive output mapping designer that allows you to choose tables, fields, column headings, and other such criteria without using any SQL.
  • Read data from popular file formats such as CSV, JSON or XML and upsert that into database tables using a visual input mapping designer.
  • Migrate or synchronize records between numerous database servers using multiple Database Connectors.

Key Features

  • Process incoming messages into your SQL Server database in real-time.
  • Highly flexible mapping configuration enables XML data processing to insert data to one or more SQL tables.
  • Create new outbound messages from your SQL Server database based on a query that is automatically set to a polling interval
  • Efficient use of transactions ensures data is updated simultaneously into your database
  • Easy-to-use XML templates dictate the format of inbound and outbound data to SQL Server
Download Connector Documentation
Version: 20.0.7488
07/02/2020

Ready to get started?

Let our expert engineering team help you make the most of your data connectivity investments.


Contact Us