ApexSQL is a Serbia-based software provider that focuses on 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 a pleasure to deliver several projects for ApexSQL.
Team composition
5 members
Client name
ApexSQL
Expertise used
Duration
5 months
Services provided
Custom software development, Software architecture, UI/UX design, Manual testing, Automated testing, System integration services
Country
United States of America
Industry
In modern market conditions, a business player must be faster than others while also delivering the highest quality at the same time. That’s why it is integral for any company where workflow involves processing SQL Server data to have precise and highly automated BI loading powers.
The technical priority at hand was to extend the functionality of existing BI loaders ApexSQL had. We needed to enable them to capture data with snapshots and load it from the resulting XML file automatically. The main challenge lied in expanding the functionality of the involved basic software libraries.
Upgraded BI Loaders of ApexSQL have been supplied with additional methods of data capture and loading. They can now create snapshots of specific data and load this data from the XML snapshot file. The solution is based on the 3 underlying libraries and the Core.
SSAS – applied custom logic and reworked all basic models to enable this library to collect, serialize, and store data in XML.
SSIS – added new methods of rereading the XML data and conducted some minor tweaks.
SSRS – wrote general logic for source XML data gathering and saving.
Core – the basic element with standard methods for data serialization, encryption, and compression.
BI Loaders can now individually create data snapshots for the most convenient further data processing possible.
Captured snapshots are automatically converted to XML files for proper sorting and storage.
Data can also be extracted from XML to be reread and optimized.
Software solutions bringing business values
