TwoConnect, a Microsoft Gold partner since 1995, simplifies software development through cloud-native, integrated applications and data solutions that empower workplaces and impact the bottom line. TwoConnect has led hundreds of integration implementations covering all major industry sectors.
TwoConnect’s work with ATA RiskStation involved developing streamlined and automated processes that would collect incoming data received from various vendors, change the data into the ATA staging format, move the ATA staging data into the ATA SQL Database, and provide a way to view and analyze the data.
Building a solution with Microsoft Azure
Migration to Microsoft Azure provided ATA RiskStation with a global, scalable platform. Azure provided a workflow pattern for customer scenarios with no on-premises server or service infrastructure. Azure Data Factory was used to collect data for further processing, move that data to a central location, and publish the data to a dashboard so it could be consumed by end users. Azure Data Factory enabled ATA RiskStation to create a pipeline, copy data, configure integration runtime, and use the dashboard to analyze the data and drill down with detailed reporting. Custom dashboards were used to view a snapshot of the most current and critical data on a single page. This enabled ATA RiskStation to provide quick and accessible information to customers and to see all its most important, and often disparate, metrics in one place.
“TwoConnect worked with ATA RiskStation to implement a Microsoft Power BI and Azure Data Factory managed solution that resulted in a secure, faster, and more simplified way to gather data for their financial risk modeling solutions, on-premises or in the cloud,” said Javier Mariscal, President, TwoConnect Inc. “Integrated data dashboards streamlined all their data sources and provided business users access to information while maintaining data security and governance. The result is the ability for ATA to gather business intelligence wherever and whenever it is needed, scale quickly, improve productivity, and thereby meet the needs of their growing clientele.”
The application, which also uses Azure Batch, Azure Storage, Azure Virtual Machines, and Azure SQL, brought many benefits to ATA RiskStation. These included a modular workflow pattern to handle unique, customer-specific scenarios; elastic capabilities to scale with customer growth; visibility to all processes through the Azure Portal; and timely, as-needed upgrades of Azure Analysis Services and Azure Data Services.
With accelerated access to information, ATA RiskStation’s end users can better focus on their specialty: analyzing the business.