Category: Datawarehousing

Feed: Cloud Data Integration Software | Matillion. Author: Ian Funnell, Lead Solution Architect; Ian Funnell, Lead Solution ArchitectThis is the first blog in a three-part series on Matillion ETL deployment options.  This article describes the first of three commonly-used choices for how to manage and deploy your Matillion solution between multiple environments: for example development – test – production. Note that in this series we’re looking exclusively at options which are available through Matillion ETL’s web user interface. Additional options are available using Matillion’s REST API.  With this method, you don’t actually move any code at all!Instead, you simply run a single ... Read More

Feed: Cloud Data Integration Software | Matillion. Author: Ian Funnell, Lead Solution Architect; This is the second blog in a three-part series on Matillion ETL deployment options. This article describes the second of three commonly-used choices for how to manage and deploy your Matillion solution between multiple environments: for example development – test – production. Note that in this series we’re looking exclusively at options which are available through Matillion ETL’s web user interface. Additional options are available using Matillion’s REST API. With this method, you create multiple Projects. For example:one Project for Developmentone Project for QAone Project for ProductionYou then promote ... Read More

Feed: Cloud Data Integration Software | Matillion. Author: Ian Funnell, Lead Solution Architect; This is the third blog in a three-part series on Matillion ETL deployment options. This article describes the third of three commonly-used choices for how to manage and deploy your Matillion solution between multiple environments, for example, development – test – production. Note that in this series we’re looking exclusively at options which are available through Matillion ETL’s web user interface. Additional options are available using Matillion’s REST API.  With this method, you create multiple Matillion Instances. For example:one instance for Developmentone instance for QAone instance for ... Read More

Feed: Actian. Author: Greg Coates. 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, compartmentalized workflows that perform specific operations as part of a larger orchestrated workflow. The invoker runs each step as a separate job on Integration Manager simply by configuring the URL, username, and password. The invoker also has actions to get the job ... Read More

Feed: James Serra's Blog. Author: James Serra. Dataflows, previously called Common Data Service for Analytics as well as Datapools, will be in preview soon and I wanted to explain in this blog what it is and how it can help you get value out of your data quickly (it’s a follow-up to my blog Getting value out of data quickly). In short, Dataflows integrates data lake and ETL technology directly into Power BI, so anyone with Power Query skills (yes – Power Query is now part of Power BI service and not just Power BI Desktop and is called Power Query ... Read More

Feed: Cloud Data Integration Software | Matillion. Author: Dayna Shoemaker; Matillion are excited to announce that we have recently opened a new office in Denver, CO! We are thrilled to be expanding our presence and increasing our coverage in the USA.The new location comes during an exciting period of growth and following our $20 million Series B round of funding. We are happy to be situated in the center of downtown Denver, just a short flight from Silicon Valley and New York.Where you can find usOur new office is in the WeWork – Tabor Center office, in downtown Denver, Co.Interested in ... Read More

Feed: Cloud Data Integration Software | Matillion. Author: Ian Funnell, Lead Solution Architect; Matillion uses the Extract-Load-Transform (ELT) approach to delivering quick results for a wide range of data processing purposes: everything from customer behavior analytics, financial analysis, and even reducing the cost of synthesizing DNA.The Jira Query component presents an easy-to-use graphical interface, enabling you to pull data from Atlassian Jira directly into Google BigQuery. Many of our customers are using this to help integrate Jira project management data with information held in other systems.The connector is completely self-contained: no additional software installation is required. It’s within the scope ... Read More

Feed: James Serra's Blog. Author: James Serra. There are two really great features just added to Power BI that I wanted to blog about: Composite models and Dual storage mode.  This is part of the July release for Power BI Desktop and it is in preview (see Power BI Desktop July 2018 Feature Summary).  I’ll also talk about a future release called Aggregations. First a review of the two ways to connect to a data source: Import – The selected tables and columns are imported into Power BI Desktop.  As you create or interact with a visualization, Power BI Desktop uses the imported data.  You ... Read More

Feed: Cloud Data Integration Software | Matillion. Author: Dayna Shoemaker; Matillion is hitting the road with AWS to speak at the Transformation Days across North America. Join us at one of our stops to see how Matillion ETL is changing the data integration game! Stop by our booth for a demo and tips and tricks from our Solution Architects, who are data warehouse experts.AWS Transformation Days offer incredible insights about enterprise cloud strategies for companies on their data-driven journeys. They bring together experts from across the cloud computing spectrum to help you understand and implement the best solution to meet your specific ... Read More

Feed: Cloud Data Integration Software | Matillion. Author: Dayna Shoemaker; Matillion’s Solutions in Cloud Commerce Helps Google Cloud Customers load and transform data on Google BigQuery, fast, simply and at scale.MANCHESTER, England, July 23, 2018 – Matillion today announced that it has received the 2017 Google Cloud Partner Award for Innovative Solution in Cloud Commerce. This year’s award was presented at the Google Cloud Next Partner Summit, an event that showcases Google Cloud partners spanning G Suite, GCP, Maps, Devices, and Education in San Francisco.Matillion was recognized for this year’s award due to the company’s contribution to Google Cloud solutions through their expertise in Cloud Commerce ... Read More