How to Link External Data to Salesforce via Salesforce Connect

Salesforce Connect allows you to link external data, available via the OData protocol as external objects and then work with these data as with usual Salesforce objects. Thus, you can expose data from any supported cloud application or database via Skyvia Connect and then link these data to Salesforce via Salesfoce Connect. This topic describes how to link an already configured OData endpoint to Salesforce via Salesforce Connect.

Creating External Data Source and External Objects

First, you need to create an external data source in Salesforce. For this, perform the following steps:

In Lighting Interface

1.In the top right corner of the page click Setup, and then click the Setup menu item.
 
01-Setup
2.In the menu on the left, under Administration, click Data, and then click External Data Sources.
3.Click New External Data Source.
4.Enter values for External Data Source (a user-friendly name) and Name (unique external data source identifier) boxes.
5.In the Type list select Salesforce Connect:  OData 4.0
6.Select the Writable External Objects check box if you use an endpoint to a writable data source.
2-External-Data-Editor
7.You may specify other settings, such as High Data Volume depending on your data in the data source.
8.If you created user accounts with passwords for your endpoint in Skyvia, you also need to configure Authentication settings. Set Identity Type to Named Principal, Authentication Protocol to Password Authentication, and specify the endpoint Username and Password.
 
2-External-Data-Editor2
9.Click Save.
10.Click Validate and Sync
 
03-Sync
11.Select exposed tables you want to sync and click Sync. This will create the necessary external objects automatically.

In Classic Interface

1.In the top right corner of the page click your name and then click Setup.
 
11-Setup
2.In the menu on the left, under App Setup, click Develop, and then click External Data Sources.
3.Click New External Data Source.
4.Enter values for External Data Source (a user-friendly name) and Name (unique external data source identifier) boxes.
5.In the Type list select Salesforce Connect:  OData 4.0
6.Select the Writable External Objects check box if you use an endpoint to a writable data source.
7.You may specify other settings, such as High Data Volume depending on your data in the data source.
8.If you created user accounts with passwords for your endpoint in Skyvia, you also need to configure Authentication settings. Set Identity Type to Named Principal, Authentication Protocol to Password Authentication, and specify the endpoint Username and Password.
 
2-External-Data-Editor2
9.Click Save.
10.Click Validate and Sync
 
03-Sync
11.Select exposed tables you want to sync and click Sync. This will create the necessary external objects automatically.

Adding Tabs for External Objects

After defining external data source and external objects, you may add tabs for external objects in order to work with them via Salesforce UI.

In Lighting Interface

1.In the top right corner of the page click Setup, and then click the Setup menu item.
 
01-Setup
2.In the menu on the left, under Platform Tools, click User Interface, and then click Tabs.
3.In the Custom Object Tabs pane click New.
4.Select the required Object and set the Tab Style and Description.
 
31-Custom-Tab-classic
5.Click Next.
6.Specify the tab visibility settings and click Next.
7.Configure the tab availability for custom apps and click Save.

 

In Classic Interface

1.In the top right corner of the page click your name and then click Setup.
 
11-Setup
2.In the menu on the left, under App Setup, click Create, and then click Tabs.
3.Click New.
4.Select the required Object and set the Tab Style and Description.
 
31-Custom-Tab-classic
5.Click Next.
6.Specify the tab visibility settings and click Next.
7.Configure the tab availability for custom apps and click Save.

 

That's all, your tab is ready, now you can work with your external objects. By default, however, the list view on this tab does not display any useful field. You can edit this view and select the fields from the external object it displays if necessary.