facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
Does FHIR Fully Address Healthcare Data Interoperability Silo Challenges?
  • December 9, 2021

Does FHIR Fully Address Healthcare Data Interoperability Silo Challenges?

Let's face it, information withholding is common in many industries, but it’s been especially rampant in the healthcare space.  Payers and Providers have avoided scrutiny for the cost of care delivered and the reimbursements they were collecting.  Consequently, information blocking has become one of the key impediments in shifting from a fee-for-service (FFS) model…

Read More
Performance Testing Production Workloads For Ingres And Vector
  • November 9, 2021

Performance testing production workloads for Ingres and Vector

One of the main concerns of Ingres and Vector customers whose systems need to undergo a significant change, such as major version upgrades, OS migration, major software releases, increased volumes of usage, etc, is how to properly test the database under realistic conditions in a test environment. Some customers have heard of the Query,…

Read More
Affinity Analytics Using Actian Avalanche Cloud Data Warehouse
  • October 29, 2021

Affinity Analytics using Actian Avalanche Cloud Data Warehouse

Affinity analytics is the practice of finding relationships and patterns in data.   Businesses can use the results from affinity analytics for many positive impacts.   Here are just two examples from real customer use cases.  First, in retail, management wants to know what products typically sell well together for product placement and advertising purposes. This…

Read More
What Is An Enterprise Data Hub?
  • October 25, 2021

What is an Enterprise Data Hub?

When managing big data, organizations will find that there will be many consumers of the vast amounts of data, ranging from applications and data repositories to humans via various analytics and reporting tools. After all, the data is an expression of the enterprise, and with digital transformation, that enterprise is increasingly expressed in the…

Read More
What’s New In Zen V15: Easily Tracking Data Changes
  • September 22, 2021

What’s New in Zen V15: Easily Tracking Data Changes

Data maintenance is an ongoing requirement in every database environment. Archiving historic data, synchronizing data after off-line access, or auditing changed data are all issues that typically require customized programming.  Most of these solutions often need database design changes or time-consuming processes to complete these tasks.  With the release of Zen v15, there is…

Read More
Data Migration: A Roadmap To Success
  • August 13, 2021

Data Migration: A Roadmap To Success

Organizations initiate data migration projects for several reasons. They might need to overhaul an entire system, upgrade databases, establish a new data warehouse, support a cloud migration roadmap, or merge new data from an acquisition or other source. Data migration is also necessary when deploying another system that resides next to incumbent applications. Regardless…

Read More
The  Top 10 Benefits Of An Operational Data Warehouse For 2021
  • August 1, 2021

The Top 10 Benefits of an Operational Data Warehouse For 2021

The previous blogs in this series discussed the top 5 pitfalls of traditional operational data warehouses and defined the Operational Data Warehouse (ODW) as a potential solution.  Below is a list of my Top 10 desirable benefits of an effective ODW: Current. Continuous data updates via “micro-batches” or streamed singleton updates throughout the day…

Read More
Hybrid Data Conference Recap And Highlights
  • June 17, 2021

Hybrid Data Conference Recap and Highlights

That's a Wrap! Wow! What a wonderful time we had at the 2021 Hybrid Data Conference! Over the course of two days, we showcased amazing demos, customer stories and technology advancements across the Actian portfolio. For those in attendance, we hope you enjoyed the event and opportunity to see a few of the ways…

Read More
The Need For Speed In Data Analysis
  • December 16, 2020

The Need for Speed in Data Analysis

Why Performance Matters My very first sales call to an analytics prospect was with a customer using an OLTP database for reporting. Some of their reports took hours to run and one particularly challenging report typically ran for more than thirteen hours. Our performance benchmarking had shown that for analytics workloads, Actian would be…

Read More
Turning Data Measurements, Metrics, And Performance Indicators Into Results
  • December 1, 2020

Turning Data Measurements, Metrics, and Performance Indicators into Results

Data is everywhere. There is data inside our organizations and outside. Some data is in the form of measurements. Measurements can be descriptive, predictive, or for diagnostic reasons. In either case, we measure to make decisions based on the quantity and quality of something. Measurements can give us actionable operational, tactical, and strategic metrics…

Read More
Speedier Interactions With Actian Zen From Node.js
  • October 15, 2020

Speedier Interactions with Actian Zen from Node.js

Make faster calls using the high-speed Btrieve 2 API Developers building real-time, data-intensive Edge applications are increasingly turning to Node.js. It’s not in itself a programming language but an open-source, multi-platform, run-time environment that leverages JavaScript and its ecosystem — and turns out to be quite well suited for today’s data streaming and JSON…

Read More
How Well Do You Actually Know Your Customers?
  • August 5, 2020

How Well Do You Actually Know Your Customers?

One of companies’ biggest mistakes is assuming they understand their customers’ needs, preferences and buying behaviors when they are actually just guessing. The better you understand who your customers are, the more successful you will be developing products and services to serve their needs, packaging them in a desirable way and communicating your offers…

Read More
SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part Two
  • June 11, 2020

SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part Two

Part Two: Rethinking What Client-Server Means for Edge Data Management Over the past few weeks our SQLite Blog series has considered the performance deficiencies of SQLite when handling local persistent data and looked at the performance complications created by the need for ETL when sharing SQLite data with back-end databases. In our last installment—Mobile…

Read More
Actian Vector For Hadoop File Format Is Faster And More Efficient
  • June 5, 2020

Actian Vector for Hadoop File Format is Faster and More Efficient

In this third and last part of the series on Actian Vector in Hadoop (VectorH), we will cover how the VectorH file format supports the performance and efficiency of our data analytics platform to accelerate business insights, as well as some of the other enterprise features that can help businesses move their Hadoop applications…

Read More
DataConnect Studio – Making Integration Even Easier
  • May 11, 2020

DataConnect Studio – Making integration even easier

Actian DataConnect was designed to make integrating your data sources easy so you can realize the vision of “connecting anything, anywhere, anytime.”  The latest updates to the DataConnect Studio make integration even easier with an enhanced set of features to enable you to set up new connections and map data quickly. Mapping Wizard The…

Read More
Developing A 360-Degree View Of Your Customer With Connected Data
  • April 29, 2020

Developing a 360-Degree View of Your Customer With Connected Data

How well do you know your customers?  Do you know what they buy?  Do you know when and why they make purchases?  Do you know who influences their buying behavior?  Do you know how price sensitive they are and what types of promotions they respond to?  You should know these things.  Connected data can…

Read More
Connected Data Makes Compliance Easier
  • April 22, 2020

Connected Data Makes Compliance Easier

Regulatory compliance can be a headache for any company.  If you do business globally, the challenge is even more significant.  Governmental regulations vary greatly across countries and even within local regions.  If that weren’t difficult enough, add on a continuous stream of regulatory changes, and you have a real problem.  Whether you are trying…

Read More
Getting Started With Avalanche On Azure
  • October 21, 2019

Getting Started with Avalanche on Azure

Actian Avalanche on  Microsoft Azure launched this week with a free cloud storage offer.  This post will walk you through getting set up on Avalanche on Azure. You must first have an Actian account as a customer of Avalanche or have signed up for a free trial.   After you log in to the Avalanche service, you…

Read More
Elastic Scaling In Actian Avalanche
  • October 4, 2019

Elastic Scaling in Actian Avalanche

Moving applications to the cloud, users can benefit from various opportunities the cloud environment offers. One of these opportunities is the availability of a seemingly infinite amount of resources, enabling users to match their requirements by scaling their application according to their load. Nevertheless, load may change over time and does not always follow…

Read More
Five Tips For Teradata Migration Success
  • September 19, 2019

Five Tips for Teradata Migration Success

If you are like most companies that currently use Teradata appliance, you may be exploring options for a new, modern data warehouse that is a better fit for today’s cloud-centric world. But don’t make the migration journey an afterthought. Teradata is a big, complex system full of rich, unique SQL syntax that predates standardization.…

Read More
Should You Have Separate Document, Time-Series, NoSQL And SQL Databases Or Can A Single Database Support All Of These Data Types And Requirements?
  • July 31, 2019

Should You Have Separate Document, Time-Series, NoSQL and SQL Databases or Can a Single Database Support All of These Data Types and Requirements?

Managing and analyzing heterogeneous data is a challenge for most companies, which the oncoming wave of Edge Computing-generated datasets has only exacerbated. This challenge stems from a rather large “data-type mismatch” as well as how and where data has been incorporated into applications and business process. How did we arrive here? At one time,…

Read More
It’s Not The Destination But The Journey – How Smart IT Managers Are Forging Their Data Warehouse Path To The Cloud
  • July 30, 2019

It’s not the Destination but the Journey – How Smart IT Managers are Forging Their Data Warehouse Path to the Cloud

As Ralph Waldo Emerson once said, “it’s not the destination it’s the journey”. Unfortunately, this wise saying is not nearly applied as often as it should be to the contemporary topic of data warehouse modernization project design and execution. The result, thousands of data warehouse modernization projects unnecessarily end up in failure. Gartner’s Adam…

Read More
Connecting To Actian Avalanche Via JDBC
  • June 12, 2019

Connecting to Actian Avalanche via JDBC

Actian Avalanche delivers an operational data warehouse as a managed service in the cloud. Its developer-friendly high-performance analytics engine has been proven to outperform other popular analytics platforms without specialized hardware or complicated software development. Requires minimal setup, provides automatic tuning to reduce database administration effort and enables highly-responsive end-user BI reporting. This is…

Read More
Connecting To Actian Avalanche from Denodo via JDBC
  • June 1, 2019

Connecting to Actian Avalanche from Denodo via JDBC

Actian Avalanche is the world’s fastest analytic data warehouse delivered as Software as a Service (SaaS). It has been designed for simplicity and doesn’t require any complex tuning to deliver consistent real-time performance for even the most challenging queries.    Actian Avalanche is standards based, supporting the latest SQL, ODBC and JDBC standards, which enables it to easily fit into any…

Read More
Connecting To Actian Avalanche from Pentaho via JDBC
  • May 21, 2019

Connecting to Actian Avalanche from Pentaho via JDBC

Actian Avalanche delivers an operational data warehouse as a managed service in the cloud. Its developer-friendly high-performance analytics engine has been proven to outperform other popular analytics platforms without specialized hardware or complicated software development. Actian Avalanche requires minimal setup, provides automatic tuning to reduce database administration effort and enables highly-responsive end-user BI reporting.    This is how to connect…

Read More
Moving Your Data To The Cloud? Read These Helpful Tips.
  • April 1, 2019

Moving Your Data to the Cloud? Read These Helpful Tips.

When you talk to IT professionals about cloud migration, the conversation is likely to gravitate towards migration of applications from on-premises infrastructure to public and/or private cloud environments. The application-centric perspective is understandable as applications are often the visible interface between business users and the technology platforms they leverage.  What many IT practitioners forget…

Read More
How A Hybrid Integration Platform Can Accelerate Data Migration
  • March 13, 2019

How a Hybrid Integration Platform Can Accelerate Data Migration

Companies around the world are migrating their IT and business applications from on-premises data centers to cloud environments. The benefits of hosting apps in the cloud are clear and well understood; however, the process of data migration is much more challenging than one would think. Migrating data between different applications that are either located…

Read More
Announcing The Availability Of Actian DataConnect On AWS Marketplace
  • March 12, 2019

Announcing the Availability of Actian DataConnect on AWS Marketplace

We are excited to announce that Actian DataConnect suite of products are now available on the Amazon Web Services (AWS) Marketplace. Actian DataConnect is a hybrid integration solution that enables you to quickly and easily design, deploy, and manage integrations on-premises, in the cloud, or in hybrid environments.  DataConnect engineered to help you cost-effectively integrate diverse data…

Read More
Connecting To An Actian X (Ingres) Database From PHP Via JDBC
  • March 8, 2019

Connecting to an Actian X (Ingres) Database from PHP via JDBC

We have documented the best way to connect from PHP to an Ingres database via ODBC in an Actian Knowledge Base article called Ingres ODBC with PHP and in a previous post, Connecting to Actian X (Ingres) with PHP and NGINX. Sometimes, however, due to limitations, users may need to use JDBC instead of ODBC…

Read More
Data Integration: The Connective Tissue Of Business
  • December 7, 2018

Data Integration: The Connective Tissue of Business

People, products, processes and systems may come and go, but, regardless, of the structural components of your business, data is the one thing that brings all the pieces together, so you can perform as a cohesive unit. There is no question modern businesses are evolving quickly. Market opportunities are short-lived, technology advancements are happening…

Read More
What’s New In Actian DataFlow Version 6.6.1?
  • November 26, 2018

What’s new in Actian DataFlow version 6.6.1?

Actian DataFlow is a parallel workflow platform for end-to-end data access, transformation, preparation, and predictive analysis that eliminates performance bottlenecks in your data-intensive applications.  Complementary to the Actian Vector analytic database, DataFlow leverages concurrency, parallelism and pipelining to accelerate data movement between locations in your data architecture, creating faster results.  DataFlow eliminates memory constraints,…

Read More
What Is An Operational Data Warehouse And Why Is It The Next Big Thing?
  • October 23, 2018

What is an Operational Data Warehouse and why is it the next big thing?

Data warehouses have been around for decades, and have established themselves as reliable reporting systems with consistent value. They have also evolved into data marts, specialized appliances and EDW variants to meet emerging needs, but all of these solutions have their drawbacks when it comes to meeting today’s business demands. Some of the common…

Read More
The Top 5 Pitfalls Of Traditional Data Warehouses
  • October 11, 2018

The Top 5 Pitfalls of Traditional Data Warehouses

Over the past two decades, data warehouse solutions have evolved and diverged to address a myriad of use cases. Meanwhile, the pace of business continues to accelerate, making it harder to remain competitive. These new demands can stretch the abilities of traditional data warehouses. Below are 5 of the common pitfalls that can trip…

Read More
Actian DataConnect V11.3 Released
  • August 3, 2018

Actian DataConnect v11.3 Released

Greetings Actian DataConnect Community, It’s my pleasure to announce the availability of Actian DataConnect version 11.3 and I’d like to introduce you to some amazing new features! Orchestration Invoker The new Orchestration Invoker process design component provides you with the ability to create more reliable and efficient integration templates by invoking combinations of smaller,…

Read More
Actian Vector Data Ingestion
  • July 11, 2018

Actian Vector Data Ingestion

The usefulness of an analytic database is closely tied to its ability to ingest, store, and process vast quantities of data. Data is typically ingested from multiple sources such as operational databases, CSV files, and continuous data streams. In most cases, daily data loads are measured in tens or hundreds of millions of rows,…

Read More
New Improvements To Security And Performance In Actian Vector
  • June 12, 2018

New Improvements to Security and Performance in Actian Vector

We are pleased to announce the availability of Actian Vector 5.1.  This release includes enhancements across the product, but the primary focus is with security, performance, and new customer enablement. This post provides an overview of some features added to this release. Security With the advent of GDPR we’ve seen heightened focus on security.…

Read More
Vector Enterprise Edition Now Available On AWS Marketplace
  • May 8, 2018

Vector Enterprise Edition Now Available on AWS Marketplace

Last week we activated Actian Vector Enterprise Edition on the AWS Marketplace, so now it’s easier to tap into the fastest analytic engine in the cloud to extract insights from your big data. We can prove that claim based on independent benchmarks by MCG that you can view here comparing Vector performance to results…

Read More
Deploying Actian OpenROAD Applications With Loadnrun
  • May 1, 2018

Deploying Actian OpenROAD Applications with Loadnrun

One of the main challenges for an application developer is the deployment of applications. There are many ways this is handled, from using traditional installers to web-based deployments. The initial web deployment option for OpenROAD, Actian's rapid application development and flexible deployment solution, was the eClient where the application itself was hosted on a web…

Read More
How Actian Vector Helps You Eliminate OLAP Cubes
  • April 16, 2018

How Actian Vector Helps You Eliminate OLAP Cubes

OLAP (OnLine Analytical Processing) Cubes are used extensively today, because it is impossible for many database platforms to analyze large volumes of data quickly. This is because most database software does not fully leverage computing power and memory to deliver optimal performance. Some of the symptoms of this are: Large queries end up hogging…

Read More
Ingres (Actian X) Disaster Recovery
  • March 29, 2018

Ingres (Actian X) Disaster Recovery

Most production Ingres (now called Actian X) installations have a need for some degree of disaster recovery (DR).  Options range from shipping nightly database checkpoints to off-site storage locations to near real-time replication to a dedicated off-site DR site.    Ingres, Actian's enterprise hybrid database, ships with built in checkpoint and journal shipping features which…

Read More
Actian’s March Topcoder Challenges
  • March 24, 2018

Actian’s March Topcoder Challenges

Actian is sponsoring three challenges on Topcoder this month, featuring our Vector and Zen database products and thousands of dollars in prizes. All you need to do is sign on to Topcoder (for free), read and follow the instructions for the competition, and win! It's that easy. Now, the challenges themselves are all different,…

Read More
Actian Vector – Community Edition Launches On Azure Marketplace
  • March 20, 2018

Actian Vector – Community Edition Launches on Azure Marketplace

Last November we announced that Actian Vector - Community Edition, our high-performing SQL analytics solution for the cloud, launched for free on the AWS Marketplace. Now we're happy to announce that a similar version has now been released on the Microsoft Azure Marketplace in a similar free-to-use pricing model. If you are a SQL…

Read More
Jolt Your Performance With Actian In Detroit And Cambridge This Week
  • March 12, 2018

Jolt Your Performance with Actian in Detroit and Cambridge This Week

Interested in jolting your data analytics and database performance? Join Actian in two separate meetings this week in both Detroit, Michigan and Cambridge Massachusetts to talk about hybrid data, performance, analytics, and dataintegration: Tuesday, March 13: Come to the JOLT YOUR PERFORMANCE BREAKFAST between 7:30–9am at the award winning Apparatus Room Restaurant conveniently located…

Read More
Making Actian Zen Btrieve API Code More Efficient
  • March 9, 2018

Making Actian Zen Btrieve API Code More Efficient

The release of Service Pack 1 for Zen (PSQL) v13, Actian’s zero-dba, embedded nano-footprint database, provides a number of new features, including one we’re looking at today to make Btrieve API code more efficient -- the GetNextExtended LIKE Support. First, let's review the concept of "Extended Operations." The low-level Btrieve API (also known as the…

Read More
Automatically Synchronize Your OLTP And OLAP Tables In Actian X (Ingres 11)
  • February 9, 2018

Automatically Synchronize Your OLTP and OLAP Tables in Actian X (Ingres 11)

A key feature of the latest update to our hybrid database Actian X (Ingres 11) is the inclusion of the x100 analytics engine and support for x100 tables. Adding a world class analytics engine to Actian X’s enterprise OLTP (OnLine Transaction Processing) capability enables a new class of applications that can mix OLTP and analytic…

Read More
Python And Btrieve 2 On Windows: Accessing Actian Zen Data With No SQL
  • February 2, 2018

Python and Btrieve 2 on Windows: Accessing Actian Zen Data With No SQL

In my previous blog ("Programming the Easy Way: Accessing a PSQL Zen Database with Python and ODBC"), I showed how to easily access an Actian Zen database with Python and ODBC.  My next project was to use the new Btrieve 2 feature with Python to directly interface with the data files without using any…

Read More
Simplifying Development With OpenROAD JSON-RPC
  • January 17, 2018

Simplifying Development with OpenROAD JSON-RPC

With the release of the new patches at the end of December for version 6.2, Actian OpenROAD (our rapid application development and flexible deployment solution) is providing a new functionality in the form of JSON support and JSON-RPC support for OpenROAD Server. Those familiar with OpenROAD would know that an application server was available from version…

Read More
Integrating Python With Vector Or Actian X
  • January 12, 2018

Integrating Python with Vector or Actian X

Introduction Today we're going to look at how to get started with Actian Vector, our high-performance in-memory analytics database, and Python, one of the most oft-used languages by data scientists in recent times. Using the techniques below, you'll be able to get started with Python using Vector ODBC and JDBC. (You'll be able to use…

Read More
When BIG Data Doesn’t Have To Be
  • January 9, 2018

When BIG Data Doesn’t Have to Be

Using a Vector FARM to Make Big Data Analytics Fast and Easy I’ve been working in the IT industry a long time.   What goes around, comes around.  My favorite example is how centralized mainframe timesharing gave birth to decentralized client-server computing, now we are going back to timesharing, but in the cloud.   Technology does…

Read More
High-Performance Realtime-Analytics On Hadoop Data
  • December 27, 2017

High-Performance Realtime-Analytics on Hadoop Data

The Challenge I have spent many years working with Actian's customers on database solutions and thought it'd be useful to discuss a recent customer experience at a large media company (I will call it "XYZCo"). This experience is similar to what I continue to see with other customers and the lessons learned apply to…

Read More
Fast. Faster. Fastest.
  • December 22, 2017

Fast. Faster. Fastest.

I was fortunate enough to attend the Actian Hybrid Data Conference at which Craig Strong, who is Chief Technology and Product Officer at Hubble, talked about how they provide real-time corporate performance management (CPM) though high-speed analytics dashboards. You can watch a video recording of this presentation on the conference sessions page linked here. For…

Read More
How I Analyzed 165 Million Flight Records In Seconds On My Laptop
  • December 19, 2017

How I analyzed 165 million flight records in seconds on my laptop

It was surprisingly easy to analyze 165 million flight records my laptop. It took me just an afternoon following the Actian Evaluation guide that you can download from here. Scientists with Intel over the years to being down the cost of high performance computing. They key vector processing technology feature they needed was to…

Read More
Connecting To Actian X (Ingres) With PHP And NGINX
  • December 12, 2017

Connecting to Actian X (Ingres) with PHP and NGINX

Not long ago I spoke at the Actian Hybrid Data Conference in London about connecting Actian X (Ingres), Actian's combination of industry-leading transactional and high-speed analytic databases, to the Web. Here we present how to use a very popular web server (reverse proxy, load balancing, etc...) on Linux, NGINX, to do just that. Here's how…

Read More
Insight To Insights
  • November 28, 2017

Insight to Insights

A fellow recent hire at Actian, Walter Maguire, told me that many organizations get frustrated with having to wait into the late morning for decision support databases to be loaded and indexed or OLAP cubes to be populated with transactional data before sales analysis can be performed. This is not a new problem. I…

Read More
Reusable Templates And Macros For Actian’s Hybrid Integration Manager
  • November 3, 2017

Reusable templates and macros for Actian’s Hybrid Integration Manager

It's a pretty exciting time to be a User Experience Designer here at Actian! We are working on some great new features for Hybrid Integration Manager and I wanted to share with you two features that really promote reusability. Reusability is a reoccurring theme that we have heard from you, our customers, that we…

Read More
The X-Vector
  • November 1, 2017

The X-Vector

As an employee new to Actian I decided to dig into what makes Actian Vector a star performer.  Three specific qualities, covered below, caught my eye as I reviewed the technical overview. Vectorization: When I first heard this term, my memory went back to 30 years ago, when IBM offered my employer, Watson Calculating Services…

Read More
Delivering Real-Time Reporting At Speed And Scale
  • September 21, 2017

Delivering Real-Time Reporting at Speed and Scale

When a major UK logistics company wanted to improve reporting for its large accounts, they turned to Actian to design, implement and support the underlying database system (“LARS”) using Ingres, HVR and Vector products for its architecture. The Brief The customer had around 100 Customer Accounts Representatives dedicated to large accounts, with each Rep…

Read More
Vector In Hadoop 5.0 – New Features You Should Care About
  • September 19, 2017

Vector in Hadoop 5.0 – New Features You Should Care About

Today we announce the introduction of the next release of Actian Vector in Hadoop, extending our support of Apache Spark to include direct access to native Hadoop file formats and tighter integration with Spark SQL and Spark R applications. In this release, we also incorporate performance improvements, integration with Hadoop security frameworks, and administrative…

Read More
Can Your Applications Find You?
  • August 8, 2017

Can Your Applications Find You?

One important trend in database management is integrating location data better to improve insights about events and activities that matter to your business. …Interest in analyzing geospatial/location data has increased over the past four years from 26% to 36%.” Source: Gartner Survey Analysis: Big Data Investments Begin Tapering in 2016, September 2016   Tracking customer…

Read More
DataConnect 11.1 Highlights
  • July 19, 2017

DataConnect 11.1 Highlights

I am excited to share news of our most recent release of DataConnect 11.1. This release wraps up a significant phase in that it provides backwards compatible support for our customers who use EDI x12, HIPAA, and HL7 connectors and components. If you use Data Integrator version 9 to process those documents, you can…

Read More
Four Tips To Accelerate Your ServiceNow Integration Using Actian PointConnect
  • June 20, 2017

Four Tips to Accelerate your ServiceNow integration using Actian PointConnect

Deploying new applications is a fact of life in business. But oftentimes, a seemingly simple integration can quickly become more complex and costly than anticipated. If you are one of the thousands of organizations planning to use, or already using, ServiceNow, you’ll want to keep in mind a few things to make your investment…

Read More
Predictions For The Hybrid Data Landscape
  • May 30, 2017

Predictions for the hybrid data landscape

The Age of Data has arrived, with new data sources, targets and processing models proliferating madly across enterprises of all sizes. While data has never been more valuable to a business — it now informs the who, what, where, when and how of decision making — this new hybrid data landscape introduces new challenges.…

Read More
Introducing Actian DataConnect 11
  • May 11, 2017

Introducing Actian DataConnect 11

We are proud to introduce the latest release of Actian DataConnect. We listened to our customers and adopted a 'back to basics' approach with the new product architecture. A lightweight desktop installation for design and a flexible SDK and CLI for run-time are the core components which will plug into any existing job management…

Read More
Connecting ServiceNow To Other Applications’ Data Doesn’t Have To Be Difficult
  • May 4, 2017

Connecting ServiceNow to other applications’ data doesn’t have to be difficult

We're excited to be at Knowledge17 this year to show how the Actian hybrid integration platform can connect ServiceNow to your existing data sources, including on-premises and cloud-based applications. The ServiceNow model can define, structure and automate the flow of work within your enterprise, but only if you can connect to other applications and…

Read More
HTAP At Actian: The Best Of Both Worlds In Data Management
  • April 26, 2017

HTAP at Actian: The Best of Both Worlds in Data Management

One of the most exciting trends for the balance of this decade will be HTAP, or Hybrid Transactional/Analytical Processing - a recently-coined term representing the next generation of hybrid, converged software infrastructure that can handle both traditional Transactional Data Management AND modern Analytic Data Management workloads. Every business is struggling to find new tools…

Read More
Hybrid Data Is A Gamechanger
  • April 19, 2017

Hybrid Data is a Gamechanger

Imagine this scenario - you have just "clicked" on an item that you are ordering online. What kind of "data trail" have you generated?  Well, you are sure to have generated a transaction - the kind of "business event" that goes into a seller's accounting system, and then on to their data warehouse for subsequent sales…

Read More
Hadoop Short Circuit Reads And Database Performance
  • August 2, 2016

Hadoop Short Circuit Reads and Database Performance

If you've been working with Hadoop then you've likely come across the concept of Short Circuit Reads (SCRs) and how they can aid performance. These days they are mostly enabled by default (although not in "vanilla" Apache or close derivatives like Amazon EMR). Actian VectorH brings high performance SQL, ACID compliance, and enterprise security…

Read More
Efficient ETL In An Analytical Database?
  • June 27, 2016

Efficient ETL in an Analytical Database?

Recently I worked on a POC that required some non-standard thinking. The challenge was that the customer's use case did not only need high performance SQL analytics but also a healthy amount of ETL (Extract, Transform, and Load). More specifically, the requirement was for ELT (or even ETLT if we want to absolutely precise).…

Read More
Performance Troubleshooting Tips For Actian Vector In Hadoop
  • June 20, 2016

Performance Troubleshooting Tips for Actian Vector in Hadoop

Actian Vector and Vector in Hadoop are powerful tools for running queries efficiently. However, most users of data analytics platforms seek to find ways to optimize performance to gain incremental query improvements. The Actian Service and Support team works with our customers to identify common areas that should be investigated when trying to improve…

Read More
Actian Vector Extends Dominance As Certifiably Fastest!
  • June 13, 2016

Actian Vector Extends Dominance as Certifiably Fastest!

Actian announced a new record TPC-H result with Hewlett Packard Enterprise and Intel to demonstrate the big data analytics performance of the new Intel Xeon processor E7-8890 v4.  With over 2.14M QphH and $0.38/QphH, Actian Vector sets new records for performance and price/performance on non-clustered systems for the 3000GB scale factor.  These numbers beat…

Read More
Accelerating Spark With Actian Vector In Hadoop
  • May 9, 2016

Accelerating Spark with Actian Vector in Hadoop

One of the hottest projects in the Apache Hadoop community is Spark, and we at Actian are pleased to announce a Spark-Vector connector for the Actian Vector in Hadoop platform (VectorH) that links the two together. VectorH provides the fastest and most complete SQL in Hadoop solution, and connecting to Spark opens up interfaces…

Read More
Pssst .. Have You Heard About VectorH?
  • May 4, 2016

Pssst .. Have you heard about VectorH?

Hello World! We’ve been busy building some innovative features into the Actian Vector in Hadoop (VectorH) product and we would love to tell you all about them. So, the list of the features and innovations that we have done recently for VectorH… wait .. do you even know what VectorH is about? Yes, it’s…

Read More
  • May 3, 2016

Amazon EMR as an Easy-to-set-up Hadoop Platform

Recently I helped a customer perform an evaluation of Actian Vector in Hadoop (VectorH) to see if it could maintain “a few seconds” performance as the data sizes grew from one to tens of billions of rows (which it did, but that’s not the subject of this entry). The customer in question was only…

Read More
Taking Advantage Of Ordered Data
  • May 2, 2016

Taking Advantage of Ordered Data

Actian Vector and Vector in Hadoop (VectorH) have a lightweight, but very potent, feature that can give a significant performance boost when querying data that possesses some kind of ordering. This entry takes a look at this feature and describes how to use it. The feature utilises what are referred to as MinMax structures.…

Read More
  • April 28, 2016

Actian Developer Tools available on Github

The Actian technology teams have recently posted a number of technical tools and snippets to the Actian account on Github that will be of interest to customers, partners and prospects. We encourage all of you to take a look and make contributions of your own – either to enhance these tools, or else to…

Read More
Analytics Cube And Beyond
  • April 14, 2016

Analytics Cube and Beyond

Big Data engineering has invented a seemingly endless supply of workaround solutions.  These are for both scalability and performance problems.  Ultimately, our approach to solving these problems dictates how sustainable they will be.  This post compares some modern best practices with pre-processing cube environments.  3 Ways A Hadoop Database Competes With Cube Analytics Software…

Read More