posts - 88 , comments - 3 , trackbacks - 0

Lightning Connect to SQLite External Objects

Use the CData Cloud Driver for SQLite to securely provide OData feeds of SQLite data to smart devices and cloud-based applications. Use the cloud driver with Salesforce Lightning Connect to create SQLite objects that you can access from apps and the dashboard.

The CData Cloud Driver for SQLite enables you to access SQLite data from cloud-based applications like the Salesforce console and mobile applications like the Salesforce1 Mobile App. In this article, you will use the cloud driver and Salesforce Lightning Connect to access SQLite external objects alongside standard Salesforce objects.

Set Up the Cloud Driver

If you have not already connected successfully from the cloud driver administration console, see the "Getting Started" chapter in the help documentation for a guide.

Connect to SQLite Data as an OData Data Source

Follow the steps below to connect to the cloud driver's SQLite feed.

  1. Log into Salesforce and click Setup -> Develop -> External Data Sources.
  2. Click New External Data Source.
  3. Enter values for the following properties:
    • Label: Enter a label to be used in list views and reports.
    • Name: Enter a unique identifier.
    • Type: Select the option "Lightning Connect: OData 2.0".
    • Server URL: Enter the URL to the cloud driver's OData endpoint. The format of the OData URL is https://your-server:8032/api.rsc.
  4. In the Authentication section, set the following properties:
    • Identity Type: If all members of your organization will use the same credentials to access the cloud driver, select "Named Principal". If the members of your organization will connect with their own credentials, select "Per User".
    • Authentication Protocol: Select Password Authentication to use basic authentication.
    • Certificate: Enter or browse to the certificate to be used to encrypt and authenticate communications from Salesforce to your server.
    • Username: Enter the username for a user known to the cloud driver.
    • Password: Enter the user's authtoken.
Configuration settings for the data source. (QuickBooks is shown.)

Create Objects Synchronized with SQLite Data

After you have created the external data source, follow the steps below to create SQLite external objects that reflect any changes in the data source. You will synchronize the definitions for the SQLite external objects with the definitions for SQLite tables.

  1. Click the link for the external data source you created.
  2. Click Validate and Sync.
  3. Select the SQLite tables you want to work with as external objects.
The list of tables to synchronize in Salesforce. (QuickBooks is shown.)

Access SQLite Data as Salesforce Objects

After adding SQLite data as an external data source and syncing SQLite tables with SQLite external objects, you can use the external objects just as you would standard Salesforce objects.

  • Create a new tab with a filter list view:

    A filtered list view shown on a custom tab. (QuickBooks Invoices are shown.)
  • Display related lists of SQLite external objects alongside standard Salesforce objects:

    A related list that shows an indirect lookup relationship, which links a child external object to a parent standard object. (Salesforce accounts and associated QuickBooks invoices are shown.)

Print | posted on Friday, June 12, 2015 6:47 AM | Filed Under [ salesforce odata cdata SQLite Cloud Driver ]

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

Powered by: