Simplify Your Data Access and Management  

ConnectPlus by Arbutus Analytics

 

ConnectPlus integrates the powerful capabilities of Arbutus with core business applications like Excel and Power BI

 

It enables organizations to extend advanced analytics, data cleansing, and consolidation capabilities directly into the familiar tools users already know and rely on. Whether deployed on desktop or server environments, ConnectPlus makes it easy to load data from selected Arbutus projects and tables directly into Excel spreadsheets and Power BI dashboards, enhancing both accessibility and productivity across your organization.

 

See How ConnectPlus Solves Connectivity Challenges

Who ConnectPlus Is Designed For?  

ConnectPlus serves three distinct user groups, each with unique needs. 

Data consumers who work with Power BI or other dashboard applications can connect their visualizations to real-time refreshed results produced by Arbutus analytics workflows and procedures.

IT and data administrators benefit from an agile solution for supporting users and projects involving Excel and dashboards, with ConnectPlus also serving as a light ETL or prototyping option.

Business analysts can leverage the power of Arbutus advanced analytics while continuing to work in the applications they know best, eliminating the need to learn new tools.

User Types

Why Organizations Choose ConnectPlus

Deliver Trusted Analytics - Provide business users with governed, analytics ready data prepared through Arbutus workflows and procedures.

Reduce Manual Effort - Eliminate repetitive spreadsheet preparation, reconciliation, and manual data manipulation.

Extend Analytics to More Users - Allow Excel and Power BI users to benefit from advanced analytics without needing to learn a new platform.

Support Real-Time Reporting - Enable dashboards and spreadsheets to connect to refreshed results generated by Arbutus analytics workflows.

Leverage Existing Investments - Continue using familiar tools such as Excel and Power BI while strengthening analytics and data quality.

Simplify Data Access - Connect disparate and legacy data sources into a consolidated, trusted analytics environment.

Arbutus CP 500px

How ConnectPlus Works: Four Simple Steps

Implementing ConnectPlus follows a straightforward four-step process that gets you up and running quickly

  1. Prepare Data with Arbutus
    Use Arbutus to access, cleanse, combine, and analyze data from multiple sources.

  2. Connect to Analytics Projects
    Map ConnectPlus to Arbutus projects and datasets.

  3. Deliver Data into Business Tools
    Provide analytics-ready data directly (via ODBC) into:
    » Excel
    » Power BI
    » Access
    » Other ODBC-compatible applications 

  4. Refresh & Reuse
    Users continue working within familiar applications while benefiting from refreshed analytics outputs and governed data delivery.

This streamlined workflow enables rapid deployment and minimizes the time from installation to productive use. The refresh functionality ensures that updates made in Arbutus are automatically reflected in connected applications, maintaining data currency without manual intervention.

 

Try ConnectPlus - Download the UserGuide

Diagram 2 Connect Plus

Key Benefits That Set ConnectPlus Apart 

ConnectPlus delivers measurable value across multiple dimensions

  • Organizations achieve better data quality and results in existing reporting applications without requiring wholesale system replacements.

  • The cost-effective licensing structure makes it economical to deploy advanced analytics to larger user groups, democratizing access to sophisticated data analysis capabilities.

  • Administrators can easily set up and support data access for dedicated Excel users, reducing support burden and increasing user satisfaction.

  • Companies successfully support advanced analytics to much broader audiences without facing typical user adoption challenges, as employees don't need to learn new tools to benefit from better analytics.

  • ConnectPlus simplifies the resource-consuming challenge of adapting to the ever-changing needs of Excel and Power BI users

Technical Capabilities and Configuration  

ConnectPlus provides robust technical capabilities through ODBC connectivity, offering flexibility in deployment and configuration. The solution supports both 32-bit and 64-bit ODBC Data Source Administrator environments, ensuring compatibility across diverse system architectures.

Computed fields created in Arbutus tables are automatically made available when loading data into core applications, preserving analytical logic and calculations. Administrators can control field visibility by excluding specific fields from being loaded, maintaining data governance and security requirements.

The system supports auto-running procedures and workflows that automatically execute when tables are opened via ConnectPlus, enabling dynamic data refresh and regeneration before loading into applications. While ConnectPlus references one project at a time by default, organizations can establish separate instances of the ConnectPlus driver to access multiple Arbutus projects simultaneously, each pointed at unique project files.

From ODBC
 

What Users Say About ConnectPlus -

Organizations using ConnectPlus report better data quality in existing reporting applications, cost-effective deployment of advanced analytics to larger user groups

"We’ve expanded analytics access without increasing adoption challenges."
"We now have better data quality and results in our existing reporting applications"
"Our employees don’t need to learn a new tool to get better analytics."
"Simple administration that supports Excel users’ data access needs, encourages broad adoption with minimal user resistance, and requires no learning curve employees keep working in Excel while gaining stronger analytics."
"ConnectPlus brings Arbutus advanced analytics straight into the tools you already use, like Excel and Power BI, no new software to install, and no complex training required. Whether you are an Excel power user, data administrator, business analyst, or dashboard designer, ConnectPlus connects advanced analytics with your day-to-day work."

Modernize Reporting with Trusted Analytics

Arbutus ConnectPlus helps organizations extend advanced analytics into Excel and Power BI environments - faster, simpler, and with greater confidence.

 

Schedule a meeting