SSAS loader upgrade for ApexSQL

  • ssas loader upgrade file formats

    New input file formats
  • ssas loader upgrade capabilities

    Wider capabilities
  • ssas loader upgrade boosted

    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.

ssas loader upgrade logo
ssas loader upgrade project

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.

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

Key features

ssas loader upgrade key
  • 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

Software solutions bringing business values

3 reviews
47 reviews

    Contact us

    100% data privacy guarantee

    Remove file
    Thank you!
    Your request has been sent
    We will get back to you as soon as possible

    USA (Headquarters)

    +16469803276 2810 N Church St, Ste 94987, Wilmington, Delaware 19802-4447


    +4531562900 Copenhagen, 2900 Hellerup, Tuborg Havnepark 7


    +48789743438 ul. Księcia Witolda, nr 49, lok. 15,
    50-202 Wrocław


    +4366475535405 Vilnius, LT-09308,
    Konstitucijos ave.7
    6th floor

    Faroe Islands

    +298201515 Smærugøta 9A, FO-100 Tórshavn,
    Faroe Islands


    +4366475535405 Donau-City-Straße 11 - Ares Tower, 1220 Wien


    +4366475535405 Emarat Atrium, 423 Al Wasl Area, Dubai, P.O. Box 112344


    +4366475535405 Vatslava Havela Boulevard, 4,