US

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
  • Control your project with metrics

  • Choose a suitable engagement model

  • Get an on-time software delivery guarantee

  • Benefit from well-defined QA processes

  • Get access to an extensive talent pool

  • Partner with us for end-to-end development

    Name *

    Letters can be used only

    Email *

    Type or choose *

    This field is required

    Phone

    Message *

    This field is required.

    Thank you! We will contact you soon

    Сarefully sending your request to a manager

    To top of page
    To top of page