Magnitude Gateway Salesforce Intelligent Adapter Provides more than access to raw data, these adapters come with an enriched schema for the Salesforce data, supplying a business view of the underlying data and greatly simplifying reporting and analysis.

Magnitude Gateway Salesforce Intelligent Adapter

Simplified user experience that puts immediate Salesforce data access and from many other data sources at the fingertips of business users.

Technical Overview

Magnitude Gateway Data Conenctivity Diagram for any data sourceThe Magnitude Gateway Salesforce Intelligent Adapter enables streamlined analytics and reporting on Salesforce data. Complying with both the ODBC 3.80 and JDBC 4.2 data standards, the adapter simplifies the process of connecting to data sources by enabling you to use the same connection across both types of applications. Additionally, the adapter is supported by the Magnitude Gateway Settings application, which provides a user-friendly interface for configuring and managing your connections.

The Magnitude Gateway Salesforce Intelligent Adapter is an intelligent adapter, providing predefined views that instantly organize your raw Salesforce data into meaningful tables in addition to providing access to the base Salesforce tables. Using the intelligent adapter, you can retrieve your data and organize it into meaningful sets without writing complex SQL queries to pull the data together.

More than just Salesforce raw data

Provide modular access to Salesforce data, simplified configuration and connectivity management of other data sources.

The Magnitude Gateway Salesforce Intelligent Adapter provides predefined views that organize your raw data into meaningful tables, streamlining data analysis and reporting processes.

When you connect to Salesforce using an intelligent adapter, these views become available as tables under the vGateway virtual schema. You can work with these views in your ODBC or JDBC application like any regular database table.

Views

The Magnitude Gateway Salesforce Intelligent Adapter includes the following views

Asset

The view provides asset information, such as the name, description, quantity, price, status, owner and parent asset names, purchase, installed, and usage end dates, and created and last modified dates.

Closed Opportunities

The view provides opportunity information, such as the name, description, type, amount, currency code, created and closed dates, forecast category, lead source, and record type.

Latest Notes

The view provides note information, such as the title, body, and created and modified dates; and parent object information, such as the name, type, and created and last modified dates.

Notes

This view returns information about the notes associated with opportunities, accounts, contacts, or products in Salesforce Sales Cloud. A record is returned for each note identifier.

Open Opportunities

The view provides opportunity information, such as the name, description, type, probability, stage, amount, expected revenue, currency code, created and closed dates, forecast category, lead source, and record type.

Open Opportunities Activities

This view returns information about activities of open tasks or events pertaining to open opportunities in Salesforce Sales Cloud. A record is returned for each activity identifier.

Opportunity Changes By Period

The view returns snapshots of the latest historical information about opportunities in Salesforce Sales Cloud as of the start date of the period defined in month. This information pertains to the opportunities that have close dates from the last 200 days.

Opportunity History

The view provides historical and current information about opportunities, such as the stage name, default stage sequence, probability of closure, estimated sale and revenue amounts, created and close dates, and forecast category

Opportunity Line Items

This view returns information about opportunity line items for products associated with opportunities in Salesforce Sales Cloud. A record is retuned for each opportunity line item identifier.

For more views and detailed information check our documentation >>

Features

  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps, including Microsoft Excel & Access, Tableau, Power BI, Qlik and more
  • Provides full driver and query metadata
  • Adds aggregation and join capabilities for queries
  • Passes down supported operations for increased performance
  • Support for ODBC 3.8
  • JDBC driver supports JDBC 4.2

Specifications

  • Supports Salesforce API Version 41
  • Supports 32- and 64-bit applications
  • Supports TLS 1.1/1.2
  • Uses OpenSSL 1.0.2
  • Complies with latest ODBC 3.8 specification
  • Supports Unicode
  • Supports Windows
  • Supports ANSI SQL-92
  • Connects via Salesforce’s native web services API

Get Salesforce Intelligent Adapter (ODBC & JDBC)

Analyze and report your Salesforce.com data on the BI tool of choice

Download Now 20 Days Free Trial OEM & Redistribution Licensing

Contact us

Questions? Ready to Buy?
Let's talk.

We'll get back to you within the next business day.

Evaluation and Sales Support If you are evaluating our drivers or our SimbaEngine X SDK, our Sales Engineers would be happy to assist you. If you are ready to buy or you require licensing information, please complete the form provided, or contact us by email or phone: +1-604-633-0008 x2 or connectivity@magnitude.com

We value privacy and will never share your information.