Actian recently announced the availability of Avalanche on the Azure platform, extending the capabilities already available on AWS. This announcement is exciting news for customers because it means greater flexibility and choice in selecting cloud operating environments as well as creating the opportunity for a multi-cloud deployment.
Actian DataConnect enhances the capabilities of Avalanche with a scalable Integration Platform as a Service (IPaaS) offering to help you manage connections from all of your source systems into your Avalanche data warehouse. With DataConnect, you will have the tools to acquire, prepare and deliver data to Avalanche with ease.
Establish connections to any source
UniversalConnect provides the capabilities to establish data connections for any source, including APIs, SaaS solutions, files, databases, mainframe systems, and on-premise applications. This is important because your IT environment is diverse, but the data insights you need to span the breadth of your enterprise. With UniversalConnect, you can connect your legacy systems, existing data stores, and even third-party platforms into Avalanche to make the full enterprise dataset available for analysis and reporting.
Flexible integration patterns
With DataConnect, you can execute integrations using any integration pattern, including scheduled batch processing, REST APIs, event listeners, and streaming data. Having multiple integration patterns available is because not all your data connections are the same. Real-time streaming data needs to be processed quickly to harvest maximum analytical value while some transactional data (such as that used for planning) only need to be updated periodically. The key is making sure you have the most current and correct data available for analysis at the time that it needs to be consumed. DataConnect gives you great flexibility to select the integration patterns that are best for your business.
Design integration workflows with DataConnect Studio
Managing data in your business is more than establishing a bunch of connections. DataConnect Studio gives you the capabilities to design workflows to orchestrate the flow of data throughout your IT environment. For example, you might want to:
- Extract from a SaaS system like Salesforce or NetSuite
- Standardize and enrich the data using simple functions, joins, etc.
- Transform into a simple format like CSV and optionally add columns to tag data or engineer additional data elements
- Deliver the file to a data lake (i.e., S3, ADL)
- Dynamically generate SQL statements based on the file’s schema
- Execute SQL commands by pushing them down to the database server for optimal processing
- Create an external table reference to the delivered CSV file so that Avalanche can query against it directly
- Define subsequent runs of the integration workflow to refresh the data set
The release of Avalanche on Azure opens up a host of new opportunities for you to modernize your data management capabilities and move your data warehouse to the cloud. DataConnect provides the tools to connect all your data sources into the new cloud data warehouse environment so you can get the most value out of this investment. The Avalanche platform works best when paired with a scalable IPaaS solution like DataConnect that includes robust tools for establishing connections, acquiring data sets, preparing, and then delivering them into the Avalanche data warehouse. To learn more about the DataConnect solutions and how it supports your Avalanche deployment, visit www.actian.com/dataconnect