> ## Documentation Index
> Fetch the complete documentation index at: https://docs.skypoint.ai/llms.txt
> Use this file to discover all available pages before exploring further.

#  

# Connecting Fivetran and Databricks on skyDataP

## Overview

Skypoint provides built-in connectors and the flexibility to integrate with external tools like Fivetran, dbt, Power BI, and Tableau to seamlessly import data from user databases. With Fivetran, users can securely transfer data from multiple sources to Databricks on skyDataP within a robust cloud network. This guide will walk you through the steps to set up your data pipeline.

Find the architectural outline of the data pipeline as follows:

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetrandatapipeline.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=0526793db5a4d5ef9e1ee3744318b622" alt="Alt text" width="843" height="301" data-path="doc_snippets/fivetrandatapipeline.png" />

## Prerequisite

* You have an active account with Fivetran and skyDataP & credentials to access them.

## Setup Guide to Connect Fivetran and Databricks on skyDataP

The setup involves two key steps:

* Integrating your Data Source with Fivetran

* Connect Fivetran to Databricks on skyDataP

## Step 1: Integrate your Data Source with Fivetran

Fivetran offers a comprehensive range of connectors to integrate with your databases.

1. Follow the Fivetran setup guide to configure the connectors, required to set up connection with your data source.

2. Prepare the following prerequisites for your source and destination to streamline the setup:

   * Valid database credentials

   * An active Fivetran account

   * skyData account with access to the Studio.

## Step 2: Connect Fivetran to Databricks on skyDataP

### Actions on skyData Studio

* Log in to your skyData Studio account.

* Go to Lakehouse > Workspaces.

* Click the Show Fields button to display connection strings.

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetrancopilotone.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=dc87fe93cbd16375a30fc239126adc92" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetrancopilotone.png" />

* Copy the following credentials:

  * Server Hostname
  * HTTP Path
  * Personal Access Token

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetrancopilottwo.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=6af6efa12112934518fde99f861754b0" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetrancopilottwo.png" />

### Actions on Fivetran

* Log in to your Fivetran account.

* From the left panel, navigate to Destinations.

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetranone.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=6fd988c0f9a7340baaf6e8e2400ea4cd" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetranone.png" />

* Click Add Destination.

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetrantwo.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=d9f0b6144f4084a149b672cda02be8e8" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetrantwo.png" />

* Select Databricks as your destination.

<Note>
  This selection is based on the fact that Skypoint Lakehouse is built on Databricks, ensuring seamless integration, enhanced compatibility, and optimal performance.
</Note>

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetranthree.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=913ac6ece9a96b97aba4815a5eda55e9" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetranthree.png" />

* Name the destination by following the naming convention for the destination as follows:

`skypoint_aip_<Tenant_name>__<Instance_name>_lakehouse_bronze`

**Components:**

* **`skypoint_aip`**: Identifies the skyDataP platform.
* **`<Tenant_name>`**: Placeholder for the tenant's name.
* **`<Instance_name>`**: Placeholder for the instance name.
* **`lakehouse_bronze`**: Specifies the Bronze layer in the Lakehouse architecture.

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetranfour.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=fccf4ba3625fb6edc7b8e6c8b29c438b" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetranfour.png" />

* Key in the required credentials by copying from skyData Studio.

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetranfive.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=20be54f48ab23746b353397d168d7daa" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetranfive.png" />

* Under **Authentication Type,** select **Personal Access Token** from the dropdown menu.

* Key in the personal access token in the field below.

* Click Save & Test to verify the connection.

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetransix.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=9291ee035a237421e7afd64b5e33c0f8" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetransix.png" />

### Congratulations! You’ve successfully connected Fivetran with Databricks on skyDataP. Your data pipeline is ready to sync securely!

## Post-Setup Verification

* The new connection will appear on the Destinations page.

* Click on the connection to view its details.

* Use the **Actions** menu to:

  * Test the connection

  * Rename the destination

  * Edit connection details

<img src="https://mintcdn.com/skypoint/HNIeMYRyI8pJ-92m/doc_snippets/fivetranseven.png?fit=max&auto=format&n=HNIeMYRyI8pJ-92m&q=85&s=33bdc28b2037ac90a1446c1a7d5b3e7b" alt="Alt text" width="1920" height="1089" data-path="doc_snippets/fivetranseven.png" />

## Next step

After completing the data import, start the [Master Data Management (MDM) - Stitch](stitch.md) process to develop a unified view of your customers.