Analytics Canvas connects directly to Google Analytics using the Google data API, so it can pull HUGE amounts of data out- and it also connects to databases, such as SQL Server, Oracle, MySQL, MS Access as well as providing easy access to data in Excel and text files.

Automate and schedule data loads to keep your database up to date and accurate. Capture late-arriving and re-assigned hits using a 10-day incremental load process.

Technical users can write SQL to extract specific datasets and to perform operations before writing to database tables.

Non-technical users can access data from databases without writing SQL and use a visual editor to clean and prepare data for analysis before loading it into databases, dashboards and files.

Dynamically generate SQL by passing parameters into database queries.

Monitor your data jobs by logging automation activity to your database.

Connect to multiple data warehouses in one place and perform cross database unions and joins. Canvas provides a visual editor enabling all join types and joining on multiple columns.

Connect to multiple databases in one place and move data between tables or between data warehouses.