An office worker in his cubicle analyzes a problem

TwoConnect case study

TwoConnect expedites ATA RiskStation’s data management with a migration to Microsoft Azure

Growing demands

ATA RiskStation, an industry leader in risk analysis modeling solutions for financial professionals, faced increasing business demands. The company decided it needed to simplify data access and data management to enable faster client onboarding.

Working together

ATA RiskStation reached out to data solutions company TwoConnect. After consulting with TwoConnect, ATA RiskStation elected to migrate to Microsoft Azure and implement a globally available and easily scalable platform.

Elastic scaling delivers

The solution, an Azure-based application, manages the entire data flow, from receipt to report. Azure services provide zero-effort scaling to manage ATA RiskStation’s varied use cases and customer scenarios.

Empowering workplaces

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.

“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.”

-Javier Mariscal, President, TwoConnect Inc.

Learn about Microsoft Go-To-Market Services

Microsoft supports your company’s success via co-selling and other partner programs.

HubStor case study

Learn how HubStor’s platform on Microsoft Azure helps Virgin Hyperloop One manage data.

Partnering with Microsoft pays off

The Microsoft Partner Network (MPN) is the most powerful community of its kind-larger than Amazon Web Services (AWS) and Salesforce combined.