Cubic Compass - Salesforce.com Solutions
  • Home
  • Navigator
  • Services
    • Subscription Services
    • Portfolio
    • CPQ Implementations
  • About
    • Contact

Navigator

DevOps and Data Management Tools for Salesforce™

Cubic Compass Navigator was developed over 15+ years to help automate recurring tasks common to the development and operations of Salesforce environments.

Tasks like data loading, data migration, transformation, deploying records, mass updates, data backups, and metadata snapshots are time consuming activities that add 30%+ overhead to every Salesforce team.

Navigator Benefits
Zero Regression
Navigator continuously backs up all essential Salesforce metadata and configuration data to ensure rollback and restore points are never more than 24 hours old. Integrations use intelligent external key mappings to ensure batches can be re-run without errors.

Automated Daily Integrations
Navigator continuously imports and exports data to any connection, keeping systems in sync.

Hours Saved
The Navigator toolset has saved thousands of hours off projects; which is why we're happy to share this solution with others. Large organizations ($1B+ annual revenue) use Navigator to process large volumes of Salesforce records per day.

Reduced Development and Operating Costs
When compared with time and materials consulting projects, Navigator consistently offers dramatic cost savings with it's quick installation low-code approach to operations.
Your browser does not support the video tag.
Pricing
Navigator is included for free with any active Cubic Compass service subscription, or licensed individually starting at $300 per month.

Other Systems Integrators may inquire about licensing Navigator for their own projects.

Core Features
  • DevOps Monitoring / Slack Bot
  • Connections
  • Data Tasks and Pipelines
  • Snapshots
  • Deployments
  • Data Lakes
@SFDCBot
Picture
"A Slack-Driven Approach to DevOps"

​@sfdcbot notifies Slack channels with ongoing alerts, notifications, and insights about Salesforce Operations. 
  • Reduces DevOps emails
  • Aligns teams on a focused channel
  • Create threads around events
  • Provides actionable messages with links to records
  • Random insights about org feature adoption

Connections
Connections form the basis of authenticating and moving data around. The org in which data tools are installed is established as the "Task Org", or sometimes referred to as the "Hub" org. The "Connections" tab manages several connections. Many data task types define source and target connections.

Types of connections supported:
  • Salesforce Production Org
  • Salesforce Sandbox Org
  • FTP File System
  • Amazon S3 Bucket
  • CSV File Connector
  • Microsoft SQL Server, ODBC, JDBC connections
  • Zendesk API
  • Zuora API
  • Xero API
  • Any REST or SOAP API (via Eclipse plugin)
Picture

Data Lakes
Picture
Picture
Cubic Compass data migrations and pipelines are designed and engineered to be repeatable. Data lakes provide a temporary, unstructured storage for use in staging data prior to transformation and loading.

ELT Architecture
Data Lakes support an ELT architecture, or "Extract, Load, and Transform". This helps to avoid dependencies on spreadsheets and manual data loader processes for enterprise-scale integrations. This also keeps raw data in the cloud closer to their ultimate destination.

The extract and load steps are typeless and schema-less. This allows raw data in any format to be successfully loaded into Salesforce where it awaits processing in the data lake.


Transformation processes then convert the raw data lake rows into Salesforce records, importing based on parent-child lookup dependencies.

Intelligent Resource Management
Data Science and Ops Team responsibilities are often formed around data lake principles, such that one role is solely responsible for generating and uploading flat files into the Salesforce data lake, and another team is responsible for reviewing, cleansing, and accepting data lake rows into Salesforce.


No More Excel VLOOKUPs!
Data Lakes remove the tedious task of Excel based VLOOKUPs to determine record parent IDs. Parent-child relationships are automatically mapped during migration data tasks to auto-resolve 18-character lookup IDs.

Data Tasks and Pipelines
A unit of work is a "Data Task". Many data tasks can be orchestrated in series or parallel to create "Data Pipelines".

​Common data tasks include:
  • Org-to-org Data Transfer
  • Record deployments
  • Rollup Summaries (Cross-object)
  • Import CSV files
  • Mass update records
  • Mass copy field values
  • Mass delete records
Picture

Metadata Snapshots
Picture
Navigator supports both automated and manual metadata snapshots. The metadata can be utilized in:
  • Source code version control (Github)
  • Diff and change analysis
  • Backup and restore
  • Org documentations
  • Master Data Management processes
Picture

Technical Documentation
Navigator makes extensive use of Salesforce APIs and Snapshots to generate technical documentation.

​Examples of documentation generated:
  • Executive Summary / Org Shape
  • Data Dictionaries
  • Org Metadata Documentation
  • Technical Debt Analysis
  • Master Data Management (MDM) Excel Spreadsheet

Deployments
Developed originally for CPQ configuration deployments, Cubic Compass supports the deployment of any standard or custom object record in any source-to-target org connection configuration.

This enables development team to configure products, price rules, product rules, and discount schedules in a sandbox development org, then deploy the records to production.

This results in:
  • Reliable and repeatable deployments
  • Fast iterative / incremental workflows
  • Fewer deployment errors
  • No more manual replication of CPQ or reference config data
Picture

Platform Events : Event-Based Architecture
Picture
Navigator utilizes an event-based architecture that raises a platform event for each milestone within every data pipeline, data task, snapshot, and deployment.

Examples of events:
  • DATA_TASK_START
  • DATA_TASK_COMPLETE
  • DATA_TASK_EXCEPTION
  • DATA_LAKE_IMPORT_START
  • DATA_LAKE_IMPORT_COMPLETE

Data Flows : No-Code
Based on Salesforce Flows and Lightning Orchestrator, the Cubic Compass data management methodology encourages the use of platform event and record-trigger flows.

No-Code Data Processing
Once connections and data lakes are established, any Salesforce Admin or Developer can implement 100% of data processing tasks in flows. No Apex or custom development required.


Examples of event-driven data flows include:
  • Converting data lake rows to Leads upon import
  • Data task chaining (Data Pipelines)
  • Notifying users when data tasks complete or fail
Picture

PII Data and Content Analysis
Picture
Analyze Salesforce Files and Attachments for PII (Personally Identifiable Information), dominant language, sentiment, key phrases, and other AI-driven content analysis services.

Apex and Java Extensions
For the "last mile" in complex or highly engineered integrations, Apex and Java Eclipse extensions are provided for hands-on coding.

Best practice is to wrap complex data processes in Apex invocable actions for use in the no-code flow builder environment. This creates the best of both worlds with reusable API components that make callouts for data, and flows to handle and process the data.

This also provides a clean delegation of responsibilities when building data-driven teams.
Picture

Logging, Reports, and Dashboards
Picture
All data task activities are logged to an event log for use in standard reports and dashboards.

Escalation and notification processes can be configured to auto-retry or notify users when data task exceptions occur.
Contact Us to Learn More
Cubic Compass     |     PO Box 2582 El Cerrito, CA 94530 
info@cubiccompass.com
  • Home
  • Navigator
  • Services
    • Subscription Services
    • Portfolio
    • CPQ Implementations
  • About
    • Contact