Actian Resource Library
Your connection to a world of insights on data management, integration and analytics.
- All Resource Types ()
- Case Study ()
- Datasheet ()
- Documentation ()
- Upcoming Event ()
- On-Demand Webinar ()
- Press Release ()
- Solutions Brief ()
- Upcoming Webinar ()
- Video ()
- Whitepaper ()
In this white paper “Persistent Myths of Cloud Data Warehouses” by Early Adopter Research, we debunk this myth and other common misconceptions around cloud data warehouses, and discuss what to watch out for during evaluation so you can make the smart choice.
Learn how Actian Avalanche and Looker customers benefit from better insights, faster, through secure, governed real-time visualization of operational data warehouse data.
In today’s digital world, businesses must rapidly disrupt, integrate and adapt to changing business requirements with greater agility to improve customer loyalty and create a sustainable competitive advantage.
Learn how Actian Avalanche can help you incrementally migrate or offload from your Teradata data warehouse until it can be retired according to your timeframe and your terms.
In this 3 minute video, Chris Clark of Actian Engineering details the latest feature updates in OpenROAD 6.2. These include improved Windows patching, script editing, json and testing enhancements.
Learn how Actian Avalanche achieves extremely fast performance for analytics workloads and how it can incorporate data from a broad spectrum of data repositories and applications, residing at the edge, in the cloud and existing data centers.
Learn how Actian Avalanche can help you incrementally migrate or offload from your Netezza data warehouse until it can be retired according to your timeframe and your terms.
Plurilogic uses Actian Zen to implement an RFID-based solution for automated student and asset tracking for primary and secondary schools.
Actian Zen Coredatabase for Android focuses squarely on the needs of Edge and IoT application developers, providing persistent local and distributed data across intelligent applications embedded insmart devices.
This paper discusses how Actian DataFlow solves the challenges of accelerating data preparation and transformation using its scale-up and scale-out architecture.
This informative CITO Research paper talks to the pervasiveness of hybrid data, discusses three use cases and the business impact of embracing a hybrid data management strategy.
Summary report for the five cloud databases that McKnight Consulting Group (MCG) performance tested on AWS. These include Amazon Redshift, Snowflake, Microsoft SQL Server, Cloudera Impala, and Actian Vector.
This paper discusses the evolution of analytics databases including the use of specialized schema structures and OLAP cubes to the emergence of purpose built columnar databases.
Significant change has arrived in how computing and storage consumes data concerning individuals. Merchants, data collection and aggregation companies are legally required to protect personal data. Those legal requirements are increasing this year with the enforcement of the EU General Data Protection Regulation (GDPR), which gives individuals the ability to better control their personal data.
Not all databases do a good job of protecting personal data. Read this white paper to learn more.
Actian PointConnect delivers instant, hassle-free ServiceNow integration using pre-built workflow templates that reduce your integration implementation time from days or weeks to mere hours.
Quickly achieve time-to-value and avoid the common misconceptions of ServiceNow integrations so you can simplify the maintenance of your application integration.
BXAttachment service provides BX customers the capability to send electronic support documents along with an electronic transaction as required by their trading partner. For example, a signed delivery ticket can be scanned and sent through BX attached a customer’s invoice. This will allow a supplier to fully automate processes while maintaining traditional supporting documentation.
This video highlights Ingres geospatial data capabilities and GIS functions, high volume streaming data capture and integration with third-party tools. Actian shows the development of an application that collects and decodes ADS-B flight data using a Raspberry Pi. Apache Kafka provides a message queue and loads the data into Ingres 10.2 where it can then be accessed to automatically update (every 20 seconds) an HTML web page with embedded SQL and the Google Maps API.
What’s new in OpenROAD 6.2. This first of three parts covers new features to meet new business requirements, reduce development costs, and improve the deployment experience.
The OpenROAD 6.2 Loadnrun tool manages client deployments and updates to OpenROAD applications from a central server. This deep dive into Loadnrun covers how to manage deployments and updates to any OpenROAD client machine and how to eliminate manual installation of OpenROAD applications.
BX Manager is a web-based portal where users can track and manage documents and partner relationships. The Actian Business Xchange platform is a fully automated document exchange service.
This managed Web-based data exchange service enables Operators to send and receive business information electronically in a seamless, timely and secure manner regardless of their enterprise system. It takes information from one company, translates it to their trading partner’s format, and then delivers that information precisely where it’s needed.
This managed web-based data exchange service enables Suppliers to send and receive business information electronically in a seamless, timely and secure manner regardless of the enterprise system. Information is taken from one company, translated into their trading partner’s format, and delivered precisely where it’s needed.
This managed Web-based data exchange service enables third party portals to send and receive their clients’ business information electronically in a seamless, timely and secure manner regardless of their enterprise system. BX PortalConnect is a cloud-based solution that also brings the added benefit of a 25 year legacy of integration technology and one of the most comprehensive lists of application and file adapters.
The BXOnboarding team is a veteran group with more than a decade of B2B Integration services and B2B document exchange experience. Our average implementation time is well below typical on-boarding times thanks to our streamlined implementation process and deep experience.
BX Validation allows you to check documents against custom business rules to reduce errors and rejects. Validations ensure that only correct data is sent from the Actian Business Xchange platform to the receiving party’s system.
Bx PortalConnect is a fully managed onboarding service that enables Portal providers to more rapidly connect with Buyers and Supplier systems to facilitate transfer of P2P business documents such as orders, invoices, and remittance documents.
McKnight Consulting Group (MCG) profiled Actian Vector performance on AWS compared to Apache Impala and discovered significant scalability and concurrency limitations making Actian Vector more than 100 faster at 10 TB
McKnight Consulting Group (MCG) Global Services profiled Actian Vector performance on AWS compared to Snowflake and found that that complex join queries from the Berkeley Big Data Benchmark ran up to 20 times faster on Vector. This report illustrates how scaling to 20 concurrent queries, Actian Vector’s kept pace with the user growth better than Snowflake which encountered severe concurrency limitations.
McKnight Consulting Group (MCG) Global Services profiled Actian Vector performance on AWS compared Microsoft SQL server and found that the aggregation queries from the Berkeley Big Data Benchmark ran up to 10 times faster on Vector. This report illustrates how scaling to 20 concurrent queries, Actian Vector’s kept pace with the user growth better than SQL Server.
McKnight Consulting Group (MCG) Global Services profiled Actian Vector performance on AWS compared Amazon Redshift and found that complex queries ran 13.8 times faster on Vector with 20 concurrent users. This report illustrates how database size increased scaled from 1 to 5 to 10 Terabytes the performance advantage provided by Actian Vector on Hadoop grew.
Bx SupplierConnect is a proven, fully managed and engineered web-based data exchange service to send and receive procure-to-pay business documents such as orders, invoices, and remittances, translating these documents into desired formats for ERP integration and better cash flow.
This white paper makes the case for complementing existing Teradata databases with newer analytics technology to address analytic backlogs, improve performance and lower costs.
Bx OperatorConnect supports standards such as PIDX to speed up the processing of business transactions between oil & gas operators and their various suppliers. Connect to any trading partner electronically regardless of back-office technology or trading format to streamline the cash flow process.
Bx BuyerConnect is a fully managed, web-based data exchange service that translates business documents (PO’s, Invoices, Shipping Notices, Acknowledgements) from your suppliers into a format that can be read by your own systems, streamlining transactions to reduce transaction costs, earn discounts, and avoid fees.
Business Xchange is a fully managed and engineered, web-based B2B data-exchange suite with services for both buyers and suppliers. Using Business Xchange accelerates invoicing and payments to reduce outstanding payments, increase accuracy, and improve cash flow.
Join this technical webinar to learn the key new features of DataConnect 11. See for yourself how the new Hybrid Integration Manager makes it possible for you to monitor and control all integrations from a single console.
Speakers: Mike Gualtieri, VP and Principal Analyst at Forrester and Mike Hoskins, Actian Technology and Product Evangelist
Read this document to find out how you can fast track your DataConnect 11 implementation using the expertise of the experienced Actian Professional Services team.
View this document to understand the major changes in DataConnect 11. You will also find a table of features that detail the differences between Data Integrator 9 and DataConnect 11.
Actian DataConnect allows you to Integrate anything, anywhere, anytime. Find out the different options that will support your integration needs today and in the future.
Learn how Actian DataConnect and PointConnect can help you achieve instant integration, whether it’s point-to-point or managing hundreds of connections.
This presentation contains more information on ways to deploy OpenROAD, and do so with richer and more robust support for management of OpenROAD Client-Server and OpenROAD Multitier architectures.
Draft statement of work for basic implementation services to provision, set up, and configure the NetSuite Connector for Salesforce, and provide an overview and orientation.
This click-through business agreement for DataCloud services covers licensing, usage, pricing, billing and other terms and conditions that must be agreed to for an order to be accepted.
451 Research discusses Actian’s move to combine Ingres and Vector as the new Actian X hybrid database for transactional and analytic workloads, as well as offering Vector as a standalone product.
Actian today announced a new vision and set of solutions designed to unify diverse data across the enterprise. Actian X is the first native, hybrid database that combines the power of the proven Actian Ingres OLTP database with Actian’s industry leading Vector analytics query engine to deliver break-through performance and scalability critical to powering the next generation digital enterprise.
Designed for Data Integrator 9 customers, view this webinar to learn about all the exciting changes we’ve made in the latest release of DataConnect—and how to import your artifacts in just minutes.
With experience in hundreds of integration engagements, the Actian Professional Services can make a significant difference in the success of your DataConnect deployment. We have helped numerous organizations gain significant improvements in the performance, scalability, and integration capabilities enabled by DataConnect.
Download the solution brief to learn how easy it is to connect Actian Avalanche to Spark data files as external tables and perform distributed queries across clouds and on-premise data sources.
The Actian Avalanche Migration Assessment offers a pre-defined set of professional services tailored to your requirements. The service is designed to assist you with understanding the requirements to migrate to Actian Avalanche and to impart recommendations important to your migration strategy formulation, planning, and implementation.
The Actian Avalanche QuickStart package offers a pre-defined set of professional services, tailored to your requirements. The package is designed to help you get value from Actian Avalanche quickly and efficiently
The Actian VectorH Implementation QuickStart Package is a pre-defined set of professional services, tailored to your requirements, that is designed to help you realize product value quickly and efficiently from the time of purchase.
The Actian Vector Implementation QuickStart Package offers a pre-defined set of professional services, tailored to your requirements, that is designed to help you realize product value quickly and efficiently from the time of purchase.
In this guide, you’ll learn about the top 10 key capabilities required for a true SQL in Hadoop solution as well as the decision criteria to support long term requirements.
Actian Vector in Hadoop combines the most modern, scalable, high-performing database technology with the power of Spark and Hadoop, enabling users to directly query data stored in HDFS.
Ray Wang, Constellation Research, shares common pitfalls and challenges that often over complicate hybrid-cloud integrations and provides tips to help you simplify your integration strategy.
For most companies, people are one of the most valuable assets. Ray Wang, Constellation Research, shows the best practices that enable us to interact with data in a way that makes it just as valuable as interacting with our colleagues.
Ray Wang, Constellation Research, discusses the importance of a balanced signal to data ratio within a dataset to cut through the noise and help you find the answers to the questions that provide true business value.
The three key steps to planning a successful data integration. Watch the video from Ray Wang, Constellation Research, to see the questions you should be asking before you begin.
Right now most companies have their data sitting in multiple locations requiring different point solutions. Ray Wang, Constellation Research, talks about the implications of multimodal and how this will change our use of the cloud.
Ingres is a leading enterprise-grade database management system designed to reduce IT costs and time-to-value. Ingres 10.2 adds enhancements for geospatial features, performance, system administration and internationalization. And with its new SQL capabilities, you can take your first steps into big data analytics.
Before developing your integration strategy, Ray Wang, Constellation Research, says it is important to understand the desired end result and how it will scale in the future. See how to choose a strategy that solves complex problems in a simple manner.
Actian NoSQL offers all the transactional capabilities of a robust Enterprise database, including the support of ACID transactions, distributed two phase commit, interfaces to third party transaction monitoring systems such as Tivoli, optimistic and pessimistic locking schemes and more.
FastObjects .NET consists of a core database server that provides the essential database functionality, and a set of client-side application libraries used by your application.
Actian PSQL is one of the most reliable, low maintenance, high-performance database management systems in the world. Actian PSQL v12 offers important additions: multi-core optimization, improved backup support with Actian Backup Agent and VSS, enhanced 64-bit support, updated license administration, IPv6 support and updated developer tools.
Over time, a busy database becomes fragmented as records are created, updated, or deleted. File access time grows and transaction response slows. The PSQL Defragmenter utility solves these problems by finding data fragmentation and letting you correct it while the engine is running. It rebuilds indexes and removes unused space so that clients can access files efficiently again.
Brieve 12 is an up-to-date, supported on Windows 10, ready to run your application, Btrieve 6.15 replacement. Btrieve 12 is file format and API compatible with Btrieve 6.15, allowing Btrieve 6.15 applications to run on the most current Windows OS platforms without a recompile.
OpenROAD is a database-centric, object-oriented, 4GL application development tool that lets you develop and deploy mission-critical, n-tier business applications against databases such as Ingres, Microsoft SQL Server, Oracle, and DB2 UDB. Developers using the newest release, OpenROAD 6.2, will find a much improved platform that can easily restyle existing applications, extend and customize business objects, field types and frame types and add new behaviors that either required a lot of code or simply weren’t possible before.
OpenROAD has always provided features that enable rapid application development and deployment. OpenROAD version 5.1 takes this further, providing robust support for using XML in your OpenROAD applications. Now OpenROAD Workbench can import and export applications and components using XML.
The X100 engine, from Actian’s analytic database ‘Vector’, brings to your Actian X instance the power of column-based data-storage, x86 vector-processing with in-cache direct decompression, and other notable technical advances.
Using analytics, healthcare providers and payers are improving healthcare delivery, reducing re-admissions, promoting preventive care and accelerating research.
Analyze all your customer data, not just a sampling, to gain deeper insights that can help attract and retain customers while abiding by all regulatory requirements.
Learn how to overcome today’s challenges and stay competitive by applying analytics to achieve an appropriate level of risk to maximize profits and minimize loss.
Actian X Hybrid Database is the combination of the industry-leading Ingres transactional and Vector analytic databases, bundled with world class integration and enterprise monitoring.
Actian PSQL Backup Agent works with third-party backup software to back up live databases and ensure accurate, reliable point-in-time recovery for partial or complete backups.
What is the dark side of moving to SaaS applications? Forrester describes common challenges for application development and delivery as you move to SaaS, and lists some best practices to maximize business value from integration across today’s solutions.
Actian AuditMaster operates as part of the PSQL database to log database events and transaction-driven changes, tracking accidental errors and intentional fraud, and providing a path for recovery. AuditMaster requires no changes to application code or the database, so businesses can get data access security and accountability quickly, easily, and with very low maintenance overhead.
DataExchange for PSQL offers two types of data replication solution: real-time data backup of a single PSQL database and data synchronization between multiple applications. DataExchange provides a simple to use solution for securing and protecting your mission-critical data from application downtime and data loss.
The Actian integration platform enables healthcare payers and providers, hospitals, administrators, and others to onboard new partners and customers, transform disparate data, and reduce costs while meeting compliance requirements.
Integrates data from diverse clients to enable stakeholders to make more effective decisions, increasing business productivity, efficiency and revenue, while reducing cost.
451 Research Report: Actian acts on market trends, invests in data management and integration offerings
451 Research discusses Actian’s moves to strengthen its data integration offerings to capture a greater share of the hybrid multi-purpose integration platform as a service market (iPaaS), with a framework that will enable SaaS providers to build their own common patterns of integration on the Actian platform for their customers.
Actian Vector in Hadoop continues the legacy of cutting edge innovation to bring record beating performance, unique update capabilities, YARN resource management and distributed SQL query processing to Hadoop.
Beyond blazing speed and expansive functionality, learn what the Actian Analytics Platform can do for your organization and how it can be used to create transformational value in areas like customer delight and sustained competitive advantage.
This white paper outlines the four key pillars of analytics speed that are essential to deliver transformational value with analytics: speed of development, speed of data processing, speed of deployment, and speed of response.
Actian Vector is relational database software for data analytics that exploits performance features in today’s x86 CPUs that most other relational databases do not take advantage of. Learn how exactly it exploits the CPU, how it leverages industry standard best practices and how it has helped other companies.
Actian Vector™ is a revolutionary analytic database that delivers unmatched performance and price/performance-yet requires less hardware and virtually no database tuning.
Actian DataConnect™ is the most powerful integration solution built to invisibly connect to any source. Whether you are managing an entire company or single project, DataConnect makes integration fast and easy.
The Actian Analytics Platform – Hadoop SQL Edition is the first end-to-end analytics platform built to run 100% natively in Hadoop, providing complete data discovery and analytics processing, together with industrialized SQL access to Hadoop data.
Want to access your Integration Competency?
Actian is here to help. Read this complimentary report by Gartner for a quick assessment and identify next best actions.