OpenText Voltage Structured Data Manager Integrations

Create your own database apps easily in formats that serve your business best. PC only. Access is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, Access can help you create appealing and highly functional applications in a minimal amount of time. Tailor your custom apps to your business and your customers, easily editing as needed to meet evolving needs. Using Visual Basic for Applications, automate business processes and create more useful forms and reports. Integrate data between Access and line-of-business apps using the Access connector library to generate aggregated visuals and insights in the familiar Access interface. Easily store data in SQL Server and Microsoft Azure SQL to enhance reliability, scalability, security, and long-term manageability.

Microsoft Excel is the industry-standard spreadsheet application that helps users organize, analyze, and visualize data with precision and power. Whether you’re managing budgets, tracking performance, or analyzing complex datasets, Excel simplifies every task with intuitive tools and intelligent automation. With Copilot, you can now ask Excel to write formulas, summarize data, or create visualizations—all powered by AI. From basic spreadsheets to advanced financial modeling, Excel adapts to your skill level and workflow. Its cloud collaboration through Microsoft 365 lets multiple users edit, share, and comment in real time from any device. With flexible templates, built-in charts, and cross-platform integration, Excel turns numbers into insights you can act on.

The Apache Hive data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive. Apache Hive is an open source project run by volunteers at the Apache Software Foundation. Previously it was a subproject of Apache® Hadoop®, but has now graduated to become a top-level project of its own. We encourage you to learn about the project and contribute your expertise. Traditional SQL queries must be implemented in the MapReduce Java API to execute SQL applications and queries over distributed data. Hive provides the necessary SQL abstraction to integrate SQL-like queries (HiveQL) into the underlying Java without the need to implement queries in the low-level Java API.