SQL Server

SQL Server Get Started >

Key Features

The SQL Server Snap provides read and write access to all objects in your custom SQL Server database. This Snap is equipped with dozens of functions you can perform on source data to integrate it with your other systems.

Trying to integrate your custom database applications with other corporate systems? Access all the major features of SQL Server with the custom Snaps available in SnapLogic.

Use the SQL Server Snap to connect to your SQL Server database and achieve read and write access to its objects. After you install this Snap, at which time SnapLogic analyzes all the objects in your SQL Server database and creates metadata for them, you will not need to perform any additional programming or configuration within SQL Server.

The Snap comes with building blocks that enable dozens of functions on your source data. Among the building blocks are readers and generators, such as the CSVRead, XMLRead, and DBRead functions. For every type of reader/generator, a writer building block is also included. Building blocks include operators, such as aggregate, database lookup, filter, join, merge sorter, splitter, and type converter. Also important to note:

  • Predefined building blocks are easy to extend for customization needs
  • Data access is controlled by the SQL credentials
  • Implements the basic SQL application security
  • Requires no additional configuration within SQL after installation
  • No Web Services or additional programming required to access SQLServer data after installation

The included library of building blocks can be categorized by function, as follows:

  • Readers and Generators
    • Atom RSS Read
    • CsvRead
    • DateDimension
    • DBRead
    • FixedWidthRead
    • HtmlRead
    • RssRead
    • XmlRead
  • Writers
    • Atom RSS Write
    • CsvWrite
    • DBWrite
    • FixedWidthWrite
    • Http Put/Post
    • RssWrite
    • XmlWrite
  • Operators
    • Aggregate
    • Compute
    • Constants
    • Date Operations
    • DB Lookup
    • Filter
    • Format Fields
    • Html Formatter
    • Join
    • Join – Outer Join
    • Math Operations
    • Merge Sorter
    • Mixer
    • Regex
    • Sequence
    • Sort
    • Splitter
    • String Operations
    • Type Converter
  • Special Purpose
    • DB Table Wizard
    • Execute Resource

Learn more about cloud application integration here.
Learn more about cloud data integration here.

Contact us Request Demo