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
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.
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.
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

Becoming a Self-Taught Cybersecurity Pro
Jessica Davis, Senior Editor, Enterprise Apps,  6/9/2021
Ancestry's DevOps Strategy to Control Its CI/CD Pipeline
Joao-Pierre S. Ruth, Senior Writer,  6/4/2021
IT Leadership: 10 Ways to Unleash Enterprise Innovation
Lisa Morgan, Freelance Writer,  6/8/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll