Microsoft SQL Server Integration Products and services: Product Evaluate and Perception


Backside Line:

Organizations which are already the use of Microsoft SQL Server for his or her database wishes will most probably to find that the instrument’s integration services and products (SSIS) are good enough to satisfy their wishes. It integrates simply with different Microsoft merchandise and gives information high quality and grasp information control options in addition to information integration functions.

Microsoft additionally provides a cloud-based answer referred to as Azure Integration Products and services this is very extremely rated by means of analysts. It is a excellent possibility for hybrid cloud deployments and Gartner estimates that Azure Integration Products and services “tripled its consumer base all the way through 2017, making it certainly one of just a handful of distributors with greater than five,000 consumer organizations.”

See Microsoft SQL Server Integration Products and services person critiques.

Leap to: Microsoft SQL Server Integration Products and services (SSIS) Options Desk

Corporate Description:

Based in 1975 by means of Invoice Gates and Paul Allen, Microsoft first won prominence within the 1980s when IBM selected to make use of Microsoft’s DOS because the working device for its non-public computer systems. In 1979, the corporate moved to Bellevue, Washington, and as of late it makes its headquarters within reach in Redmond. In 1990, Microsoft introduced Home windows, its flagship working device that continues to dominate the marketplace as of late. Its different standard merchandise come with the Workplace suite of place of business productiveness instrument, the Azure cloud computing carrier, the Xbox gaming device and Floor computing gadgets.

Microsoft is among the international’s greatest instrument firms and is quantity 30 at the Fortune 500 checklist. The corporate employs greater than 131,000 folks international, together with greater than 77,000 in america. In its fiscal 2018, it reported earnings of $110.360 billion and internet source of revenue of $30.267 billion. It’s traded at the NASDAQ underneath the logo MSFT, and this can be a part of the Dow Jones Commercial Reasonable and the S&P 500.

Product Description:

Microsoft SQL Server Integration Products and services (SSIS) is integrated within the Microsoft SQL Server instrument. Some 98 of the Fortune 100 use SQL Server, and the corporate lists Rolls-Royce, Infosys, Carnival, Jet and Stack Overflow amongst its consumers for the product. It contains graphical equipment for developing ELT jobs with out writing code. It standard Microsoft type, it is available in a number of variations: Specific, Specific with Complicated Products and services, Developer, Internet, Usual and Undertaking. Maximum SSIS options are to be had solely within the Usual and Undertaking variations.

SSIS is a platform for construction enterprise-level information integration and knowledge transformations answers. It might extract information from relational databases and knowledge warehouses, XML recordsdata, flat recordsdata and different assets ahead of reworking them and loading them into different packages.

Microsoft additionally provides Azure Integration Products and services, a suite of cloud-based answers for integrating information, packages and services and products. It contains the Good judgment Apps, Provider Bus, API Control and Tournament Grid services and products.

Gartner ranked Microsoft SSIS as a Challenger in its most up-to-date Magic Quadrant (MQ) file on information integration equipment. Azure Integration Products and services is a Chief within the MQ on integration platform as a carrier (iPaaS) answers.

Options:

Deployment:

SSIS may also be deployed on premises or within the cloud. Azure Integration Products and services is cloud-only.

Licensing:

Proprietary

Device Necessities:

Microsoft SQL Server runs on Home windows or Linux. Maximum Home windows editions require a 1.four GHz or sooner x64 processor (2.zero GHz or sooner advisable), 1 GB RAM (four GB or extra advisable) and six GB of cupboard space. The .NET framework will have to even be put in.

On Linux, SQL Server calls for no less than a dual-core x64 processor (2GHz or sooner), 2 GB RAM and six GB of cupboard space with the XFS or EXT4 filesystem.

Connectors

SSIS contains pre-built connectors for ActiveX Knowledge Gadgets, Excel, flat recordsdata, FTP, webservers, message queues, ODBC, OLE DB, mail servers and a couple of others. Addition connectors for Oracle, SAP and Teradata are to be had for obtain, and the instrument additionally permits customers to create their very own connections.

Design and Construction Surroundings:

Graphical atmosphere

Key Features

  • Import and export wizard
  • Integrated connectors
  • Integrated duties and transformations
  • Hadoop beef up
  • Trade Knowledge Seize
  • Knowledge mining transformations
  • Research, grasp information control, information high quality and reporting additionally to be had thru SQL Server.

Make stronger and Products and services:

Coaching, certification, beef up and services and products to be had

Pricing:

Microsoft SQL Server pricing is dependent upon the version:

  • Specific – Loose
  • Internet — To be had thru webhosting suppliers solely
  • Developer — unfastened
  • Usual — $three,7171 according to core
  • Undertaking — $14,256 according to core

Quantity licensing and different reductions could also be to be had.

Pricing for Azure Integration Products and services is dependent upon services and products used, information middle used and different elements.

Options

Microsoft SSIS

Deployment

SSIS: on-premises or cloud

Azure Integration Products and services: cloud

Device Necessities

 

Running Device

Home windows or Linux

Processor

1.four GHz x64 for Home windows

dual-core 2 GHz x64 for Linux

RAM

1GB Home windows

2 GB Linux

Garage

6 GB

Device

.NET Framework for Home windows

Connectors

for ActiveX Knowledge Gadgets, Excel, flat recordsdata, FTP, webservers, message queues, ODBC, OLE DB, mail servers, others

Design and Construction Surroundings

Graphical atmosphere

 

Key Features

 

ELT

Sure

ETL

Sure

CDC

Sure

Knowledge High quality

Sure thru SQL Server

Knowledge Governance

Sure thru SQL Server

Others

Research, grasp information control, reporting, information migration

Make stronger and Products and services

Coaching, certification, beef up and services and products

Gartner Magic Quadrant Score

Challenger for SSIS; Chief for Azure Integration Products and services

Worth

Specific and Developer editions are unfastened. Usual $three,717 according to core. Undertaking $14,256 according to core. Cloud costs range.

You May Also Like

About the Author: admin

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: