Lightning Connect Taps Real-Time Data - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Cloud // Software as a Service
08:37 AM
Connect Directly
50% Lightning Connect Taps Real-Time Data adds data-integration option for accessing up-to-the-minute data from sources such as SAP apps and Oracle databases.

10 Smart Tech Toys For Kids
10 Smart Tech Toys For Kids
(Click image for larger view and slideshow.) on Thursday introduced Salesforce1 Lighting Connect, a new data-integration option billed as the "fastest, easiest" way to view data from any source system from within Salesforce cloud-based applications.

Salesforce says Lighting Connect is different from existing integration options in that it supports point-and-click setup, real-time (rather than batch) integration, and access to data from on-premises applications and databases as if it originated in Salesforce.

A recent Salesforce survey of customer CIOs found that nearly half (48%) of respondents identified integration with on-premises systems as one of their biggest challenges. Lighting Connect was designed to "wrap a layer of agility around backoffice data," said Scott Holden,'s VP of platform marketing, in a phone interview with InformationWeek.

[Want more on mobile dev? Read Speeds App Development With Lightning.]

Salesforce points to obvious Lighting Connect advantages over primitive options like manual file uploads and file transfers. But companies with frequent data-integration needs are already likely to be using integration tools from AppExchange partners such as Informatica, MuleSoft, and SnapLogic. Even so, these and other partners are supporting Lighting Connect because it offers a new data-integration option.

The most popular data-integration approach is ETL-style loading. This typically involves overnight or even hourly batch data uploads -- either from on-premises systems (or cloud apps) into Salesforce or from Salesforce into data marts or warehouses. Many integration firms also support more sophisticated event- and message-based integration. In this more complicated, Enterprise Application Integration (EAI) approach, data is continuously copied from third-party systems into Salesforce.

Lighting Connect is simpler than EAI, offering point-and-click setup of External Objects, a new source type that Salesforce has added alongside its existing Standard Objects and Custom Objects. Users can call on these external objects for point-in-time snapshots of up-to-the-minute information. It's an approach that's geared to human querying, searching, data visualization, and simple workflows, as when users want or need to do quick lookups from smartphones or tablets.

Salesforce1 Lighting Connect lets users get an up-to-the-minute view of the latest data in on-premises systems such as SAP BusinessSuite.
Salesforce1 Lighting Connect lets users get an up-to-the-minute view of the latest data in on-premises systems such as SAP BusinessSuite.

Holden described a retail-promotion scenario in which salespeople want to see real-time sell-through data: "That order data might live in SAP, but you want to give salespeople who are out on the road visibility into how quickly different products are moving. With a check of box, you can choose which table from within SAP you want to view from within Salesforce, whether that's orders or inventory or shipment information."

The vendor will also use Lightning Connect to bring data from apps built on its cloud-based Heroku platform into Salesforce. Last year Salesforce introduced Heroku Connect for syncing data from Heroku apps with Salesforce, but Lighting Connect will add an OData-based real-time option to the Heroku Connect portfolio.

Lighting Connect is based on the emerging Open Data Protocol (OData), which is supported by vendors including Microsoft, IBM, and SAP. It's a lightweight way to access external data from within Salesforce, but the information isn't copied and stored. Thus Lighting Connect is not an EAI alternative that can be used for developing a unified view of master data across systems or powering always-on business processes. That's probably why partners including Informatica, Jitterbit, MuleSoft, Progress Software, SnapLogic, and SoftwareAG have jumped on the Lighting Connect bandwagon -- it's no threat to their ETL or EAI businesses.

"We've created an OData connector so our customers won't have to worry about creating end-point connections," said Ajay Gandhi, Informatica Cloud VP of product marketing, in a phone interview with InformationWeek. That connector is now included in the Informatica Cloud platform offered on the AppExchange, and Gandhi said it supports integration with hundreds of popular data sources and applications.

Salesforce1 Lighting Connect is available immediately, priced at $4,000 per-month, per-connection. The system has built-in links to SAP and a few other systems that support OData, according to Holden, but otherwise Salesforce is leaving the sale of application-specific connectors to its integration partners.

Apply now for the 2015 InformationWeek Elite 100, which recognizes the most innovative users of technology to advance a company's business goals. Winners will be recognized at the InformationWeek Conference, April 27-28, 2015, at the Mandalay Bay in Las Vegas. Application period ends Jan. 16, 2015.

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
Mike Kann
Mike Kann,
User Rank: Apprentice
2/7/2017 | 5:56:05 AM
Re: Data visualization with external objects?
External objects that don't expose OData can't be used by Salesforce Lightning Connect directly. That is why you need Datadirect cloud, or take a look at a new and still free Salesforce Odata producer - Skyvia Connect.
User Rank: Apprentice
3/3/2015 | 10:52:18 PM
Data visualization with external objects?
I setup Lightning Connect with external objects from my back office ERP database using OData produced from DataDirect Cloud.  Your article mentions data visualization, but my understanding is that external objects do not work with native Salesforce reporting or dashboards.  Am I missing something?
D. Henschen
D. Henschen,
User Rank: Author
11/13/2014 | 4:30:52 PM
Not quite "getting data into" Salesforce
This is viewing data from third-party systems, but I wouldn't call it "getting data into" the Salesforce platform in a persisted copy-and-store sort of way. Think of it has taking human-consumable snapshots of the latest data in those systems. It's not copied or persisted, so it's not a replacement for ETL and EAI methods that DO copy data into Salesforce and on into data warehouses.
User Rank: Apprentice
11/13/2014 | 12:39:55 PM
Game changing approach to data
Great article, Doug.  I'm hearing great things about this technology and approach from my customers.  They tell me that it is game changing for developers.  Now data can be accessed immeidately without the need for the cumbersome IT processes associated with EAI or ETL.  We all know about the information demands of various corporate departments.  Business users are craving for data, Salesforce's innovation along with key partners provides a simple way to get data into Force apps. 
D. Henschen
D. Henschen,
User Rank: Author
11/13/2014 | 9:37:10 AM picking on SAP?
It seems like is picking on SAP lately, featuring SAP customers that are working with Salesforce to do everything agile, mobile and cloud while treating ERP as, well, ERP. Lighting Connect is another example, and it just so happens SAP has embraced OData, making it easy for Salesforce to expose all that backend data within its world.

Lighting Connect is obviously good for human consumption -- supporting up-to-the-minute lookups and visualizatiosn of data -- but it's not quite clear to what degree is can power lights-out workflows and busienss processes. The data-integration vendors with enterprise application integration (EAI) chops tell me this is no replacement for the event- and message-based systems that actually copy data into Salesforce rather than just exposing it for viewing purposes.
How GIS Data Can Help Fix Vaccine Distribution
Jessica Davis, Senior Editor, Enterprise Apps,  2/17/2021
Graph-Based AI Enters the Enterprise Mainstream
James Kobielus, Tech Analyst, Consultant and Author,  2/16/2021
11 Ways DevOps Is Evolving
Lisa Morgan, Freelance Writer,  2/18/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you.
Flash Poll