Skip to main content

Connecting your data sources

For information about our industry-leading security practices, check out our Security hub.
Fabi.ai supports three types of data connections:
  1. Application connectors - Connect to SaaS applications like HubSpot, Google Ads, Shopify, and hundreds more
  2. Database & data warehouse connectors - Connect to your databases like Snowflake, BigQuery, PostgreSQL, and more
  3. Google SHeets connector - Connect your Google Sheet directly to a Fabi Smartbook
To connect a new data source, in the data panel on the left hand side of a Smartbook, click Add Data Source or go to the data connector settings page.
Description

Application connectors

Fabi.ai offers hundreds of pre-built application connectors that allow you to sync data from popular SaaS platforms directly into your analysis. These connectors make it easy to bring in data from:
  • Marketing & Advertising: Google Ads, Facebook Ads, LinkedIn Ads, HubSpot, Mailchimp, and more
  • E-commerce: Shopify, Stripe, WooCommerce, and more
  • Sales & CRM: Salesforce, HubSpot CRM, Pipedrive, and more
  • Analytics: Google Analytics, Mixpanel, Segment, and more
  • And many more…
How application connectors work:
  1. Select the application you want to connect
  2. Authenticate using your credentials (OAuth or API keys)
  3. Fabi.ai automatically syncs your data on a regular schedule
No technical configuration required - just authenticate and start analyzing!
Fabi will only get access to the data that the authenticated user has access to. Ensure that whichever user establishes the connection has access to all the data you wish to analyze.

Database & data warehouse connectors

For connecting to databases and data warehouses, you’ll need to provide connection credentials and may need to configure network access.
Description
Important: You may need to authorize Fabi.ai’s IP addresses to have access to your database. See note below.

Your cloud configuration (a note for your platform and IT team)

Before connecting, ensure that you whitelist Fabi.ai’s IP addresses in your firewall or security group settings:
  • 3.232.60.87
  • 54.172.255.171

Database connection instructions

For help generating service user accounts and tokens for specific database integrations, check out our individual pages: For any additional help getting set up, please reach out to [email protected] .

Fabi data connectors FAQ

Yes, we can work with you to make sure you’re set up properly. Reach out to [email protected] and our team will assist you with the setup process.
Yes, we offer complementary data services to help model data and prep the data. Our team can assist you in structuring your data for optimal analysis. Contact [email protected] to learn more.
Yes, we’re constantly adding new connectors and can work with you to prioritize the ones you need. Let us know which connector you’re looking for by reaching out to [email protected].
Yes. However, you need to ensure that there’s a clear ID to match on - even if it’s fuzzy matching - and you may need to provide this context to the AI. Once the matching fields are identified, Fabi can seamlessly join data across different sources in your analysis.