> ## Knowledge Base Index > Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml > Use this file to discover available pages before exploring further. > Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash). # How to Create and Use Lookup Connections in SyncSpider for DataHub Integration Creating a **Lookup Connection** for DataHub allows you to link and compare data from different sources, much like the "VLOOKUP" function in Excel. With a Lookup Connection, you can choose two different data points to compare: one from a source field and another from a DataHub table column header. The Lookup Connection will then compare these fields and return all matching items from the DataHub table, automatically populating the corresponding fields in your mapping process. **TABLE OF CONTENTS** * [Step 1: Create a Task and Access the Lookup Connection](#Step-1%3A-Create-a-Task-and-Access-the-Lookup-Connection) * [1.1 Create a Task in SyncSpider:](#1.1-Create-a-Task-in-SyncSpider%3A) * [1.2 Navigate to the Mapping Page:](#1.2-Navigate-to-the-Mapping-Page%3A) * [1.3 Access the Lookup Connection Tool:](#1.3-Access-the-Lookup-Connection-Tool%3A) * [Step 2: Set Up the Lookup Connection](#Step-2%3A-Set-Up-the-Lookup-Connection) * [2.1 Initiate the Lookup Process:](#2.1-Initiate-the-Lookup-Process%3A) * [2.2 Search for DataHub:](#2.2-Search-for-DataHub%3A) * [2.3 Select Your DataHub Integration:](#2.3-Select-Your-DataHub-Integration%3A) * [Step 3: Configure the Lookup Connection](#Step-3%3A-Configure-the-Lookup-Connection) * [3.1 Select the Source Field:](#3.1-Select-the-Source-Field%3A) * [3.2 Choose the DataHub Entity:](#3.2-Choose-the-DataHub-Entity%3A) * [3.3 Map the Relevant DataHub Field:](#3.3-Map-the-Relevant-DataHub-Field%3A) * [Step 4 : Finalize and View the Lookup Connection](#Step-4-%3A-Finalize-and-View-the-Lookup-Connection) ## Step 1: Create a Task and Access the Lookup Connection ### 1.1 Create a Task in SyncSpider: Begin by setting up a task in SyncSpider with your desired source integration. For this example, we will use **Google Sheets** as the source integration and **DataHub** as the target integration. ### 1.2 Navigate to the Mapping Page: After configuring your source and target integrations, proceed to the **Mapping** page within the task setup. ### 1.3 Access the Lookup Connection Tool: On the **Mapping** page, locate the **'Lookup Connection'** option on the right panel and click on it to begin setting up your lookup connection. ![SyncSpider mapping setup, highlighting where to create a lookup connection for data integration](https://storage.crisp.chat/users/helpdesk/website/-/7/3/a/2/73a24f6322f80800/d0c27626-5ff9-45b6-91d4-49dbf4_17dvggc.png) # --- ## ## Step 2: Set Up the Lookup Connection ### 2.1 Initiate the Lookup Process: If this is your first time setting up a lookup connection, click on the **“Create a new lookup”** button in the Lookup Connections panel. ![SyncSpider interface highlighting the 'Create a new lookup' link.](https://storage.crisp.chat/users/helpdesk/website/-/9/4/b/3/94b311829281b000/3de46218-a704-46f7-979f-41cf40_1gcokqr.png) ## ### 2.2 Search for DataHub: In the dropdown menu that appears, search for **"DataHub"** and select it as your lookup connection service. ![Dropdown menu in SyncSpider to search and select existing integrations for the lookup connection setup.](https://storage.crisp.chat/users/helpdesk/website/-/5/f/f/0/5ff07c12453c9800/7fdd98ea-78a1-4aae-8a60-4446ec_vqc7el.png) ### 2.3 Select Your DataHub Integration: Next, choose the appropriate DataHub integration from the available options that contain the data you wish to connect. ![](https://storage.crisp.chat/users/helpdesk/website/-/4/d/8/f/4d8fa4543421d800/aab2f532-61c9-4d83-845b-190fc7_q4193j.png) --- ## Step 3: Configure the Lookup Connection After selecting your DataHub integration, you will configure the lookup connection by specifying the fields you want to compare. # ### 3.1 Select the Source Field: Once your DataHub integration is selected, two dropdown menus will appear. In the **first dropdown menu**, select the source field from your integration (e.g., Google Sheets) that you want to compare with the DataHub table data. ![Selecting the source field for the lookup connection in SyncSpider.](https://storage.crisp.chat/users/helpdesk/website/-/f/3/4/8/f348d6b44da2d800/2b7425d1-cab7-46a1-bfed-c7a2ed_1vara7a.png) ## ### 3.2 Choose the DataHub Entity: In the **second dropdown menu**, choose the DataHub entity where your table is located. ![Selecting a DataHub entity from the 'Select Entity' dropdown menSelecting a DataHub entity from the 'Select Entity' dropdown menu in SyncSpider.u in SyncSpider.](https://storage.crisp.chat/users/helpdesk/website/-/2/3/9/a/239a8c198337da00/4688f797-c956-4a85-aae7-8b06ae_d4zmrz.png) ### 3.3 Map the Relevant DataHub Field: After selecting the DataHub entity, a new dropdown will appear showing the column headers from the selected DataHub table. Choose the header that corresponds to the data you want to compare with the source field. ![SyncSpider interface showing the selection of a DataHub entity and the dropdown to choose the relevant lookup field for mapping.](https://storage.crisp.chat/users/helpdesk/website/-/2/0/a/9/20a908111f1e0400/207e9188-0bf3-48e4-b4d3-d666f2_1mg1jj9.png) --- ## ## Step 4 : Finalize and View the Lookup Connection Click the **"Done"** button to finalize the creation of your lookup connection. After the connection is created, you will see a new collection available in the source fields, named after the DataHub entity you selected. This collection will contain all the relevant fields from the DataHub table, ready for use in your data mapping. ![New DataHub entity collection in SyncSpider source fields after creating a lookup connection.](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3109639008/original/fumBmOC2zjFYubsitVw3SFqBglWsjLEBbg.png?1724764457) --- We hope this guide helps you efficiently create and utilize Lookup Connections in SyncSpider. If you need further assistance, please contact us via [email protected] or use our chat widget!