Does Fresha store the passwords for my data connections?

No, Fresha does not store passwords for data connections to ensure the security of your business data. If you lose your password, you can easily generate a new one by resetting it.

What tools work with Data connector?

Many tools can connect to Fresha data using the database details provided, some examples include: Adobe - https://www.adobe.com/ Amplitude - https://amplitude.com/ Astrato - https://astrato.io/ Atscale - https://www.atscale.com/ CartO - https://carto.com/ Chart IO - https://chartio.com/ DOMO - https://www.domo.com/ Google Data Studio - https://datastudio.google.com/ IBM Cognos - https://www.ibm.com/products/cognos-analytics Looker - https://looker.com/ MachEye - https://www.macheye.com/ Metabase - https://www.metabase.com/ Microstrategy - https://www.microstrategy.com/ Mode - https://mode.com/ Oracle - https://www.oracle.com/ Pentaho - https://pentaho.com/ Power BI - https://powerbi.microsoft.com/ Pyramid - https://www.pyramidanalytics.com/ Quick sight - https://quicksight.aws/ Qilik - https://www.qlik.com/ SAP - https://www.sap.com/ Sigma - https://www.sigmacomputing.com/ Sisense - https://www.sisense.com/ Snowflake - https://www.snowflake.com/ Tableau - https://www.tableau.com/ TIBC - https://www.tibco.com/ ThoughtSpot - https://www.thoughtspot.com/

Can I connect my Fresha data with software that doens't have a snowflake integration (e.g. Quickbooks)?

Fresha will soon provide direct, native integrations with popular software but there are a number of other options to connect your Fresha data with software that doens't have a snowflake integration. Option 1: Use ETL/ELT Middleware Tools Tools like Fivetran, Stitch, or Zapier can act as intermediaries between Snowflake and your desired software. Here's how to do it: Choose an ETL Tool: Select a tool that supports both Snowflake as a data source and your desired software as a data destination (e.g., Fivetran or Zapier). Set Up Snowflake as a Source: Provide your Snowflake credentials (account URL, database name, warehouse, username, and password) to the ETL tool. Define the tables or queries from Snowflake to extract data. Set Up your desired software as a Destination: Authenticate the ETL tool with your desired software using API credentials or OAuth. Map Snowflake data to your desired software fields (e.g., invoices, expenses, etc.). Automate the Sync: Schedule regular data transfers based on your requirements (e.g., daily, hourly). Option 2: Export and Import Data For simple, manual workflows: Export Data from Snowflake: Query and export data from Snowflake into a CSV file using your existing BI tool. Import to QuickBooks: Use your desired software's import functionality to load the CSV file into relevant sections (e.g., transactions, invoices).

Help center
Knowledge base
Reports and Insights
Create new Data Connections

Create new Data Connections

Easily connect your business data to a wide variety of external tools with the Data Connector add-on. Learn how to integrate with platforms like Tableau, Power BI, and Google Data Studio to create detailed reports, uncover deep insights, and build real-time dashboards tailored to your business needs.

Creating a new data connection

Once you’ve enabled the Data connector add-on for your business, you can create new data connections with over 40 external tools.

To start syncing your data to your preferred external tools and create a new data connection:

Open the Reports tab on Fresha.
Select Data connector in the left hand panel.
Click the Add button to start creating a new data connection, and then select Continue.
Select your external tool from the list - If your tool isn't listed, choose Custom tool to connect with other platforms.
Click Create connection.
After a short time (up to 30s), your connection will be ready, and you’ll see the Database details.
Copy and paste your Database details into your external tool to connect with Fresha data:
1. Database type = Snowflake
2. Account URL (sometimes called 'Account name')
3. Username
4. Warehouse name
5. Database name
6. Schema
7. Password

You’ll also get an email with the database details for the connection you created.

Your database details include a password that can only be viewed once for security reasons. We recommend saving this password somewhere secure for future reference. If you lose the password, you’ll need to reset it on Fresha to reconnect your data.

Connecting Fresha data

You can use your provided database details to connect Fresha data (via Snowflake) from a wide variety of data tools. The specifics for how to connect will vary by product but below we give some example steps to connect to Fresha data for popular software.

Setup steps for popular tools

Adding a public key

A public key adds an extra layer of security to your connection. If your system requires secure SSH authentication, you can upload a public key to Fresha. This ensures that only authorized users can access your data.

To add a public key when creating a connection:

Open the Reports tab on Fresha.
Select Data connector in the left hand panel.
Click the Add button to start creating a new data connection, and then select Continue.
Select your external tool from the list - If your tool isn't listed, choose Custom tool to connect with other platforms.
Click Create connection.
After a short time (up to 30s), your connection will be ready, and you’ll see the Database details.
On the Database details page, click Add key.
Enter your public key into the text field.
Click Save

You can always add your public key later, for a step-by-step guide on how to do this and manage the connections you have set up, check out .

FAQs

Create new Data Connections

Creating a new data connection

Connecting Fresha data

Adding a public key

Was this guide helpful?