Ready to get started?
Let our expert engineering team help you make the most of your data connectivity investments.
Contact Us
SQL Server Connector
Automate the process of extracting data from SQL Server and converting it to XML messages, and vice versa.
The Benefits of SQL Server
- Integrate your backend SQL Server directly into your business process workflows.
- CData Arc 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
Contact Us