skip to main content
Querying with OData Version 2 : Formulating queries with OData Version 2 : Searching text-based columns with OData Version 2 : Configuring Salesforce external objects for search optimization

Try Now
Configuring Salesforce external objects for search optimization
Hybrid Data Pipeline provides the ability to configure which tables and columns are included in a search to optimize performance and avoid overloading database resources. If you use Salesforce to access external objects, and want to take advantage of Hybrid Data Pipeline's optimization, you must configure the Salesforce external data source to accept the Hybrid Data Pipeline ddsearch parameter. This can improve the performance of the OData queries generated by Salesforce to search your external objects.
To do this for an existing external data source, log into your Salesforce account and follow these steps:
*Navigate to the External Data Source Edit screen.
*Make sure that Include in Salesforce Searches is enabled.
*In the Custom Query Option for Salesforce Search field, enter ddsearch as shown below:DDC - Salesforce External Data Source Query parameter configuration
*Save your changes.
Note: Navigation to the External Data Source screen differs depending on the type of Salesforce account you have. See your Salesforce documentation for more information.