Companies around the world are migrating their IT and business applications from on-premise 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…
Organizations initiate data migrations for several reasons. They might need to overhaul an entire system, upgrade databases, establish a new data warehouse or merge new data from an acquisition or other source. Data migration is also necessary when deploying another system that resides next to existing applications. Regardless of the exact purpose for a…
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 premise, in the cloud, or in hybrid environments. DataConnect engineered to help you cost-effectively integrate diverse…
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…
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…
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…
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…
As an old-school programmer from a few decades ago, I decided to see how hard it would be to access a Zen (formerly known as PSQL) database from my newly acquired knowledge of Python. In case you're not familiar with it, Zen is Actian's embedded zero-admin, nano-footprint hybrid NoSQL and SQL database software, and…
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…
We’re pleased to announce that Actian Vector 5.0 Community Edition now includes support for Mac OS X via Docker. Over the last few years Mac OS X has become increasingly popular with Developers, as has Docker, the virtualization platform that allows you to bundle applications along with their native OS and run them in…
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…
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…
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…
Back when I started off in the industry, some 20 something years ago (I do pretend I am still in my 20s so that number has a nice ring to it) there was only one IT Department with one manager in most large organizations. Now there are multiple managers within different departments, some aligned…
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…
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…