- Adriel Academy
- Data Source Hub
- Flexible Integrations - File Sharing / Data Base
-
Getting Started with Adriel BI
-
Data Source Hub
- Overview: Connecting Data Sources
- Flexible Integrations - File Sharing / Data Base
- Adform
- Airbridge
- Amazon Ad Server (Sizmek)
- Amazon Ads
- Amazon DSP
- Amplitude
- Apple Search Ads
- AppsFlyer
- Awin
- Basis
- Branch
- Buzzvil
- Cafe24
- Coupang
- Criteo
- Facebook Page Organic
- Godomall
- Google Ads
- Google Ad Manager (GAM)
- Google Analytics 4 (GA4)
- Google Business Profile (GBP)
- Google Campaign Manager 360 (CM360)
- Google Display & Video 360 (DV360)
- Google Search Console (GSC)
- Google Sheets
- HubSpot
- Instagram Organic
- Instagram Public
- Kakao
- Klaviyo
- LinkedIn Ads
- LinkedIn Organic
- Mailchimp
- Matomo
- Meta Ads (formerly Facebook Ads)
- Microsoft (Bing) Ads
- Mobon
- Moloco
- Naver
- Outbrain
- Pinterest Ads
- Quantcast
- Quora Ads
- Reddit Public
- Salesforce Reporting
- Semrush
- Shopee
- Shopify
- Singular
- Sistrix
- Snapchat Ads
- Spotify Ads
- StackAdapt
- Taboola
- Targeting Gates
- Teads
- TikTok Ads
- TikTok Organic
- TikTok Public
- Unity Ads
- Walmart Connect
- WooCommerce
- X (Twitter) Ads
- X (Twitter) Organic
- Yahoo Ads
- Yahoo DSP
- Yelp Ads
- YouTube Analytics
- YouTube Public
-
Business Intelligence: Adriel Dashboard
-
Your Team
-
FAQ
How to connect MySQL to Adriel
Detailed instructions to help you set up the data source for MySQL
Lastly modified on: Thu, 20th June, 2024 at 03:45 PM
Prerequisites
- MySQL database
- MySQL account with a read right.
- MySQL account allowed to connect remotely to the database from the IP address: 52.79.160.224.
- Check the rights of your MySQL user.
Instructions
- Move to Adriel’s Connections page.
- Type “MySQL” into the search bar.
- Fill in the five required and optional fields accordingly to the database that you want to connect to Adriel.
- Host: Database host name
If your database is hosted behind a firewall, whitelist the following IP address: 52.79.160.224.
Check the settings of your hosting machine or your hosting provider.
- (Required)Database: Database name you want to import
- (Required)User: name of a user allowed to read data and connect to your database.
- (Required)Password: Password of your MySQL user account.
- (Required)Port: Database port; default port of MySQL is 3306
- (Optional)Alternative Channel Name: Alternative name for the data source
- No icon is provided as a default for this feature. However, there are channels that can use internally saved icons and display next to the channel name you just wrote down.
- Refer to this guide to input the correct name to display the icon.
https://academy.adriel.com/en/how-to-set-alternative-channel-name-for-file-db-data-source - Click the “Submit” button below to complete the data connection.