SSIS

 

Online transaction processing (OLTP) is a class of systems that supports or facilitates high transaction-oriented applications. SQL server integration systems (SSIS) primary system features are immediate client feedback and high individual transaction volume.

 

OLTP is mainly used in industries that rely heavily on the efficient processing of a large number of client transactions, e.g., banks, airlines and retailers. Database systems that support OLTP are usually decentralized to avoid single points of failure and to spread the volume between multiple servers.

 

OLTP systems must provide atomicity, which is the ability to fully process or completely undo an order. Partial processing is never an option. When airline passenger seats are booked, atomicity combines the two system actions of reserving and paying for the seat. Both actions must happen together or not at all.

 

Heavy OLTP system reliance brings added challenges. For example, if server or communication channels fail, an entire business chain can grind to an immediate halt.

Examples of OLTP transactions include:

  • Online banking
  • Purchasing a book online
  • Booking an airline ticket
  • Sending a text message
  • Order entry
  • Telemarketers entering telephone survey results
  • Call center staff viewing and updating customer's details

 

SQL Server Integration Services

25-September-2019

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Integration Services includes a rich set of built-in tasks and transformations, graphical tools for building packages, and the Integration Services Catalog database, where you store, run, and manage packages.

You can use the graphical Integration Services tools to create solutions without writing a single line of code. You can also program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

Sam Analytiks motivates, educates and proliferates data for any organisation as a non-profit partner. If you or any of your team member needs a help, surely our consultants will be glad to help you in any case.

Call us at +48-729473572 or email us at sam@samanalytiks.com
#data #datavisualisation #datamodelling #datamart #powerbi #sql #excel #powerquery #azure #azureanalysis 


WE ALWAYS WORK WITH :