Zoho Analytics is created by Indian-based Zoho, which generated some estimated 500 million in revenue in 2019. Using Zoho Analytics provides the largest synergies when your company uses other products from the Zoho product suite (such as Zoho CRM or SalesIQ). However, Zoho Analytics’ target audience clearly goes beyond its existing user base. In this blog post I explain how you can connect it to a PostgreSQL database in Google Cloud Platform.
Connecting Zoho Analytics to a PostgreSQL database in Google Cloud Platform is fairly easy. Go to your Cloud SQL instance in Google Cloud console. In the menu, go to Connections. Under authorized networks, add the Zoho Analytics IP addresses as follows (by the way, use CIDR notation):
In the screenshot below, you can see how I added all the European IP addresses. To find them out for your regions, please refer to this overview.
It’s good practice to make a new user that only has reading rights. In the following query, I grant my user zohoanalytics reading rights to all existing and future tables in the database covid.
CREATE USER zohoanalytics WITH PASSWORD 'thisIsAPassword';
GRANT CONNECT ON DATABASE covid TO zohoanalytics;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO zohoanalytics;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO zohoanalytics;
Once the IP addresses are whitelisted and the user is created, you can connect to the Cloud SQL instance with Zoho Analytics.
The first step is fairly easy, you copy the IP address from the SQL instance overview. Normally you don’t need to change the port. Next, add the username and the password. Finally, enter the database you want to connect to.
Step 2. You can import one specific table, multiple tables and even write your own custom query. I appreciate the possibility to write your own queries. This way, you can clean the data before it is loaded into Zoho.
In the third step, you can choose the names of the tables you are importing. As you can see, Zoho does not necessarily assign the same datatype to the columns of your database. There’s a wide range of datatypes to choose from that go beyond what databases have to offer: continents, countries, states, provinces, counties, districts, ZIP codes, airports, emails and urls.
In Step 4, you set the frequency of refreshing the data. In the free and basic version you’ll have access to a daily sync. In the standard plan and up, you can choose to sync your data on an hourly basis.
Syncing can take a while. If the data is not showing up and the table appears to be empty, wait a little bit longer. In the data sources menu, you can see the status of your table.
Once syncing is done, you can go ahead and start making dashboards.
Submit your new website to our directory and start reaching a wider audience. https://cutt.ly/X72sbGa
Vil du se op til 20 år yngre ud? Brug kosmetiske produkter fra Sereni Capelli, fremstillet i Italien, og dine grå hår vil genvinde deres naturlige farve.
Fordi du ikke længere vil have grå hår, vil du se op til 20 år yngre ud. Disse kosmetiske behandlinger anbefales til både mænd og kvinder i alle aldre.
Hvis du ikke er tilfreds med resultaterne inden for de første 21 dage, refunderer vi dine penge. Yderligere detaljer på https://serenicapelli.be
Do you have a toll free number?
You NEED this The Click Engine for your success.
Click on the link here: https://warriorplus.com/o2/a/t78fh1/0
To your success,
Karl Johnson
B2B SaaS Marketing Agency https://gignaut.com
See what we have for you https://www.bestsellermarket.com/
want to be on top 10 Google rankings without any upfront payment? I’m John, an SEO expert.
Email me at razibarkai1643@gmail.com with your site and keywords, and I’ll assess it.
I won’t charge until you reach the top 10. Nothing to lose! Waiting for your email.
Best,
John
Achieve SAAS excellence through our dedicated PPC agency, tailoring campaigns to skyrocket your software’s online impact.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me? https://accounts.binance.com/bn/register?ref=53551167
La mejor aplicación de control parental para proteger a sus hijos – monitoriza en secreto GPS, SMS, llamadas, WhatsApp, Facebook, ubicación. Puede monitorear de forma remota las actividades del teléfono móvil después de descargar e instalar apk en el teléfono de destino. https://www.mycellspy.com/es/
Hi roelpeters.be
We noticed your website roelpeters.be is only listed in 12 out of 2500 directories.
This has a severe impact on your online global presence.
You can get listed in all 2500 directories for a once off fee of $99
Come visit us on https://roelpeters.companyregistar.org/roelpeters.be
Tired of manual tasks? Let me craft custom automation scripts to streamline your work. Imagine syncing data effortlessly or generating reports with a click. From customer interactions to data analysis, let’s boost efficiency together. Say goodbye to tedious tasks and hello to productivity. Email me here: kqx0j6@mail2go.xyz
Are you looking for a capable financial company to fund your business project? I can help, email me here: info@financeworldwidehk.com
Are you looking for a capable financial company to fund your business project?
we are here to provide you with the best solution for your business growth. we provide the most suitable business loan package to meet your need.
email me here.
info@financeworldwidehk.com
Best regards,
Laura Cha.
Customer Service Representative
Are you looking for a capable financial company to fund your business project?
we are here to provide you with the best solution for your business growth. we provide the most suitable business loan package to meet your need.
email me here.
info@financeworldwidehk.com
Best regards,
Laura Cha.
Customer Service Representative
To My One and Only,
I can’t wait to see you tonight. Let’s make it a night we’ll never forget – https://cutt.ly/IeA1ZZwz