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…
When I moved to Austin 10 years ago from the California Bay Area, little did I not know that I would be working in a company that gets acknowledged as the Top Workplaces in Austin today. This accolade was nominated and selected by the employees of the company. Actian Corporation came about as a…
This month, GigaOm published a comprehensive evaluation of leading cloud data warehouse services based on performance and cost. Offerings analyzed included Snowflake, Amazon Redshift, Microsoft Azure Synapse, Google BigQuery, and our very own Actian Avalanche. There are many intriguing results included in the report, but an indisputable conclusion was reached by GigaOm: "In a…
We are very excited to share the news that The Automobile Association (AA), the UK's largest motoring organization, selected Actian Avalanche hybrid cloud warehouse for its insurance business to execute its cloud migration strategy. The AA is a leading UK automobile insurer and breakdown service provider that provides vehicle insurance, driving lessons, breakdown coverage,…
Enterprise Data Integration is the merging of data across two or more organizations. This scenario is most commonly found when companies are going through mergers or acquisitions, and data from the two companies need to be brought together. Other scenarios for Enterprise Data Integration are joint-partnerships (where two or more companies work together under…
In the first part of this two-part article, we created the model. In this installment, we will create the UDF’s in database. We can convert the model to Python, and I used m2cgen to transpile the sklearn model to Python model I will be making 3 types of UDF’s, Python UDF JavaScript UDF Saving…
Recently in Avalanche, VectorH 6.0, and Vector 6.0, Actian introduced a capability for Scalar user-defined functions (UDF’s). This has given Avalanche, VectorH, and Vector a new dimension to run Machine Learning (ML) models in Python and JavaScript within database. More about UDF’s can be found in our documentation. Model creation is simple with so…
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…
Artificial Intelligence (AI) is the core of the next wave of IT systems, and it is time to get ready. The past year has seen tremendous growth in the adoption of artificial intelligence systems to help companies improve operational insights and provide enhanced customer service experiences. If you aren’t leveraging AI to support your…
IT Service Management (ITSM) staff have a unique challenge to provide service assurance across a broad and diverse technology ecosystem. Connected data is essential to enable them to do their job effectively. Your incident and problem management staff don’t know what they don’t know. They can only see the data that is made available…
If you are simply “lifting and shifting” data from one place to another, you are missing out on the power that a data integration platform can bring you. It is time to look beyond extract, transfer, load (ETL) from individual source systems, and expand your integrations to include multi-source joins that enable you to…
In the first part of my blog on Real-Time Decision-Making (RTDM) highlighting Retail industry use cases, we discussed how combining existing historical data patterns with disparate new sources of data completes the Common Operational Picture (COP). To illustrate the use-case, we used an Actian customer, Kiabi, and how they used RTDM strategic capabilities to…
In my last blog on Real-Time Decision-Making (RTDM), I shifted from a theoretical discussion of what RTDM is to uses cases that highlight key aspects of the value it can bring to business in periods of market uncertainty. I'm using the Retail Industry because its an Industry everyone knows something about coupled with the…
In the last blog on Real-Time Decision-Making (RTDM), we discussed exactly what it is and why it matters. Before proceeding with more theoretical discussions, though, it’s probably worthwhile to give you some practical examples of RTDM and how data management, integration, and analytics support, build RTDM strategic capabilities that significantly impact business operations. Retail:…
Robotic process automation (RPA) is one of the fastest-growing trends in the IT industry. This next-generation of workflow management capabilities is poised to be an essential enabler for companies seeking to optimize their digitally transformed business processes for peak efficiency. For RPA vendors, one of the critical capabilities that must be developed in your…
How Avalanche and DataConnect work together to deliver an end-to-end data management solution Migrating to a cloud data warehouse makes strategic sense in the modern context of cloud services and digital transformation. Operationally, connecting disparate data sources into your cloud data warehouse, managing ongoing change in your IT environment, and delivering on the promises…
