#MYSQL SSH TUNNEL UPDATE#
#MYSQL SSH TUNNEL OFFLINE#

After the MySQL credentials page opens, toggle the Encrypted button to Yes.

Go to Manage Data > Connections and click the Add New Data Source button.

In the next section, we'll create the user and import the key. The public key is used to authorize the Magento BI Linux user.

It's not as complicated as it might sound. To connect your MySQL database to Magento BI via an SSH tunnel, you (or your team, if you're not a techie) will need to do a few things:

Enter the connection and user info into Magento BI.

Allow access to the Magento BI IP address.

How does Google Analytics UTM attribution work?.

Identifying your most valuable marketing sources and channels.

Understanding and building basic analytics.

Analyzing repeat probability decay and churn.

Year-over-year, month-over-month, week-over-week.

Recency, frequency, monetary (RFM) analysis.

Analyzing Website Activity and Customer Conversion Rates.

Analyzing customer repurchasing behavior.

Track User Device and Browser Data in your Database.

Track User Acquisition Source Data Overview.

Expected Lifetime Value (LTV) Analysis (advanced).

Expected Lifetime Value (LTV) Analysis (basic).

Increasing ROI on your advertising campaigns.

Analyzing coupon impact on acquiring and retaining customers.

Connecting MySQL via a direct connection.

Connect Your MySQL Database to Magento BI.

Expected Google Analytics Warehoused Data.

#MYSQL SSH TUNNEL OFFLINE#

Importing offline / other ad spend data.Importing CJ Affiliate (Commission Junction) Marketing Data.Formatting and importing eCommerce data.Understanding Results Between Database and SQL Editor.Differences in Columns Between SQL and Data Warehouse Manager.Auditing Metrics Using the SQL Report Builder.Understanding the Repeat Order Probability Report.Why does the time to first purchase report slope downward?.Are there any integrations I can't use with the SQL Report Builder?.Are SQL Report Builder queries case-sensitive?.

#MYSQL SSH TUNNEL UPDATE#

Do I have to rebuild my queries after every update cycle?.Ordering data using the Show Top/Bottom feature.Why is the Lifetime Revenue Cohort Analysis Important?.Create Google Analytics charts (with regex syntax help).What's the difference between the Report Builder and the SQL Report Builder?.Does deleting a SQL report/query also delete the underlying columns from my Data Warehouse?.Using the Cohort Report Builder for Non-Date Based Cohorts.Using the Sequential Comparison Calculated Column.Using the Event Number Calculated Column.Using the Date Difference Calculated Column.Understanding and Evaluating Table Relationships.Translating SQL queries into Magento BI reports.Replicating Google Analytics channels using acquisition sources.

Creating and Using a SQL Calculated Column.Creating and Using Data Warehouse Views.Building Google ECommerce dimensions with order and customer data.

Mysql ssh tunnel