US

SSAS Loader Upgrade for ApexSQL

  • file-formats

    New input file formats

  • capabilities

    Wider capabilities

  • Boosted-1

    Boosted performance

Project
overview

The SQL Server system must always be kept in check and updated to deliver the highest performance possible. Data loading is a major thing to optimize and accelerate where the need be. SSAS loader is one system aspect that can be boosted for the ultimate data loading benefit.

Client
information

ApexSQL is a software provider based in Serbia that specializes in Microsoft SQL solutions. The company is working with a huge number of corporate giants (such as Microsoft, NASA, Intel, and others) and holds a strong position in its niche of business. We’ve had the pleasure to deliver several projects for ApexSQL so far.

logo
overview-4

Business
challenge

Digital business players rely heavily on web technologies and specialized software. Up to date, SQL Server is the most widely used database management system that helps keep corporate and other kinds of data intact. That’s why it should be maintained properly. Namely, standard systems should be expanded and kept updated to meet the custom requirements of particular companies. Existing features must be upgraded and kept fresh.

Technical
challenges

With the SSAS loader upgrade, we had to expand the capabilities of the existing class library that collects all metadata on the server, databases, and stored objects via the connection to the live Analysis Services server. All in all, the major task was to update the engine with new input databases – XMLA file and SSDT SSAS project.

Solution
delivered

The updated SSAS Loader is able to load metadata from XMLA files as well as from SSDT SSAS project files. In both cases, both tabular and multidimensional data can be loaded. The loader supports all SSAS server version XMLA files and can be added up with additional metadata. The feature also went through unit testing, and error logging through the pre-existing ApexSQL.Common.Logging library.

Solution-4

Claim a 30-minute talk with our experts and get a step-by-step strategy for your project for free!

Key features

key-features-4
  • XMLA files as input data sources

    XMLA files can now be conveniently used to extract the required tabular or multidimensional metadata.

  • SSDT SSAS project as an input data source

    SSDT SSAS project assets can now also be extracted and exposed through the object hierarchy for more convenience.

VALUE TO OUR CLIENT

  • New input file formats

    Being able to load data from two new source formats - XMLA and SSDT SSAS - the SSAS Loader becomes ultimately more versatile in its work.

  • Wider capabilities

    With new input data source integrated, the existing engine can be used for a wider array of tasks and purposes.

  • Boosted performance

    The SSAS Loader engine becomes faster in performance overall, loading data from several input sources at once.

Our Tech Stack

  • ch C#
  • Visual-Studio-1 Visual Studio
  • net .NET/ASP.NET

contact us

    Name

    Email

    Phone

    Become a customer
    How we can help you

    Message

    Thank you! We will contact you soon

    Trusted partner who delivers on scope, on time and on budget

    To top of page
    To top of page