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
hi
Greetings from USA
We are interested in your products.
Kindly send your product details/catalog and price list if your company can handle a bulk supply order to overseas.
Send your catalog and brochure to:-: procurement@strategyconsultings.com
MrSmith
Don’t let high costs drain your wallet! For only $20/month, you can save on gas, groceries, and so much more—anywhere in the world.
https://kristi.savingshighwayglobal.com/?page=membership
Take the first step toward smarter spending today!
Disclaimer: Individual results will vary. This is not a savings or earnings guarantee.
Hi, this is a friendly reminder that this is the last chance for USA based businesses to file their claim to receive potential compensation owed to you from the Visa/Mastercard $5.5 Billion Dollar settlement. You can learn more here: https://visascardsettlement.com
Want to generate amazing content? Need videos or text-to-speech? Check out these 3 Amazing AI Tools:
**Create stunning videos
**Produce written content quickly
**Convert text to realistic speech
Get started today! http://3amazingaitools.top/
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 with no upfront fee just notary approval.
email me here.
mailto:info@financeworldwidehk.com
Best regards,
Laura Cha.
Customer Service Representative
$VIDROCKET: AI Video fuel!
Powering the future of accessible viral content with AI!
Solana speed, viral potential.
Get ready to ignite your gains.
Get in NOW
https://pump.fun/coin/EuDnV5YCrey9BygRktnBtHtLETPAo7uFaZsXsZQTpump
Hi there,
Every day, countless small businesses deliver outstanding products and services — but many remain unseen simply because they lack the massive marketing budgets of big corporations.
Their dedication, passion, and quality deserve to be noticed, appreciated, and chosen.
That’s exactly why AutoBuzz.ai was created — by a team of tech professionals who deeply understand this struggle. They’ve faced the same challenges: trying to get noticed without spending thousands on agencies or complex tools.
So they built a solution designed for businesses like yours:
✅ AI-generated professional promo videos in minutes
✅ No tech skills required
✅ Affordable and accessible for startups and small teams
✅ Fast turnaround — ready-to-share content for social media and your website
With AutoBuzz, you can finally showcase the true value of your work and stand out in your market — without a big marketing department behind you.
Now even the smallest businesses can access tools once reserved for the giants.
Ready to give your business the visibility it deserves?
Discover it : https://jvz9.com/c/3091907/416189/
Limited-time launch offer: $27 one-time fee.
And remember: the minds behind this tool have walked in your shoes. That’s why it works so well.
Regards
Mike Dalton
World’s First Universal AI App That Allows You To Search & Unlock Any AI Model In The World…
And Access It With Just One Click From One Dashboard
Finally, Access (ChatGPT,DeepSeek, Runaway ML, Leonardo AI, DALL-E, Pika Labs, Canva AI, Claude 3, Gemini, Copilot, Hugging Face, ElevenLab, Llama, MidJourney, AgentGPT, Jasper, Stable Diffusion, Synthesia, Perplexity AI, Open AI Whisper, and 350+ more) Without Paying Their Hefty Fees
And much more … http://www.novaai.expert/EveryAI