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.
Team composition
5 members
Client name
ApexSQL
Expertise used
Duration
5 months
Services provided
Custom software development, Software architecture, Manual testing, Automated testing, System integration services
Country
United States of America
Industry
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.
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.
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.
XMLA files can now be conveniently used to extract the required tabular or multidimensional metadata.
SSDT SSAS project assets can now also be extracted and exposed through the object hierarchy for more convenience.
Software solutions bringing business values
