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
Sorry, this is not a valid link or file is not found.