[Vtigercrm-developers] Vtiger & Google Data Studio

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

[Vtigercrm-developers] Vtiger & Google Data Studio

socialboostdk
Hi there,

Does anyone have experience with connecting VTiger to Google Data Studio? 

There is as an example a MySQL option, but JSON as an example.

Thanks :)



_______________________________________________
http://www.vtiger.com/
Reply | Threaded
Open this post in threaded view
|

Re: Vtiger & Google Data Studio

Nilay Khatri-2
Use Google sheet as intermediate data house.

On Fri, Sep 6, 2019, 4:50 PM socialboostdk <[hidden email]> wrote:
Hi there,

Does anyone have experience with connecting VTiger to Google Data Studio? 

There is as an example a MySQL option, but JSON as an example.

Thanks :)


_______________________________________________
http://www.vtiger.com/

_______________________________________________
http://www.vtiger.com/
Reply | Threaded
Open this post in threaded view
|

Re: Vtiger & Google Data Studio

Estefan Civera-2
did you try  to use redash?

On Sun, Sep 8, 2019 at 12:38 PM nilay khatri <[hidden email]> wrote:
Use Google sheet as intermediate data house.

On Fri, Sep 6, 2019, 4:50 PM socialboostdk <[hidden email]> wrote:
Hi there,

Does anyone have experience with connecting VTiger to Google Data Studio? 

There is as an example a MySQL option, but JSON as an example.

Thanks :)


_______________________________________________
http://www.vtiger.com/
_______________________________________________
http://www.vtiger.com/


--
//---------------
// Estevan
// +393207728697
//---------------

_______________________________________________
http://www.vtiger.com/
Reply | Threaded
Open this post in threaded view
|

Re: Vtiger & Google Data Studio

Oleg
In reply to this post by Nilay Khatri-2
I use it with direct MySQL connection to vTiger database. Data studio have issues... for example it can not filter using non Latin symbols. Error messages do not have much information. And you have to build query on your own. Make new datasourse for each aspect of análisis.
It is month income/expense report on the picture attached.


El El dom, 8 sept 2019 a las 13:46, nilay khatri <[hidden email]> escribió:
Use Google sheet as intermediate data house.

On Fri, Sep 6, 2019, 4:50 PM socialboostdk <[hidden email]> wrote:
Hi there,

Does anyone have experience with connecting VTiger to Google Data Studio? 

There is as an example a MySQL option, but JSON as an example.

Thanks :)


_______________________________________________
http://www.vtiger.com/
_______________________________________________
http://www.vtiger.com/
--
--
С уважением, руководитель веб-студии PIN
Антонов Олег.
+7-921-922-91-91

- Создание и продвижение сайтов
- Автоматизация бизнеса
- Увеличение продаж


_______________________________________________
http://www.vtiger.com/
Reply | Threaded
Open this post in threaded view
|

Re: Vtiger & Google Data Studio

joebordes

metabase and superset are also interesting alternatives. all have the issues of losing the user privileges though...


El 8/9/19 a las 15:26, Oleg Antonov escribió:

I use it with direct MySQL connection to vTiger database. Data studio have issues... for example it can not filter using non Latin symbols. Error messages do not have much information. And you have to build query on your own. Make new datasourse for each aspect of análisis.
It is month income/expense report on the picture attached.


El El dom, 8 sept 2019 a las 13:46, nilay khatri <[hidden email]> escribió:
Use Google sheet as intermediate data house.

On Fri, Sep 6, 2019, 4:50 PM socialboostdk <[hidden email]> wrote:
Hi there,

Does anyone have experience with connecting VTiger to Google Data Studio? 

There is as an example a MySQL option, but JSON as an example.

Thanks :)


_______________________________________________
http://www.vtiger.com/
_______________________________________________
http://www.vtiger.com/
--
--
С уважением, руководитель веб-студии PIN
Антонов Олег.
+7-921-922-91-91

- Создание и продвижение сайтов
- Автоматизация бизнеса
- Увеличение продаж


_______________________________________________
http://www.vtiger.com/

_______________________________________________
http://www.vtiger.com/
Reply | Threaded
Open this post in threaded view
|

Re: Vtiger & Google Data Studio

Luke Carazzo
In reply to this post by Nilay Khatri-2
I use Metabase as well. I create and report and then print the query and then use the query to manipulate a report and dashboard in Metabase. I have dashboards for all my modules.

Below is a link for tickets or I call it job cards and I manage the progress of Job cards etc.

http://www.imagine-ts.co.za:3000/public/dashboard/7c4f3cd1-2fc1-4656-a001-1a80e7f95093




-----Original Message-----
From: [hidden email] <[hidden email]> On Behalf Of [hidden email]
Sent: Monday, 09 September 2019 2:00 PM
To: [hidden email]
Subject: vtigercrm-developers Digest, Vol 164, Issue 5

Send vtigercrm-developers mailing list submissions to
        [hidden email]

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers

or, via email, send a message with subject or body 'help' to
        [hidden email]

You can reach the person managing the list at
        [hidden email]

When replying, please edit your Subject line so it is more specific than "Re: Contents of vtigercrm-developers digest..."


Today's Topics:

   1. Re: Vtiger & Google Data Studio (Joe Bordes)


----------------------------------------------------------------------

Message: 1
Date: Sun, 8 Sep 2019 15:31:50 +0200
From: Joe Bordes <[hidden email]>
To: [hidden email]
Subject: Re: [Vtigercrm-developers] Vtiger & Google Data Studio
Message-ID: <[hidden email]>
Content-Type: text/plain; charset="utf-8"; Format="flowed"

metabase and superset are also interesting alternatives. all have the issues of losing the user privileges though...


El 8/9/19 a las 15:26, Oleg Antonov escribi?:

>
> I use it with direct MySQL connection to vTiger database. Data studio
> have issues... for example it can not filter using non Latin symbols.
> Error messages do not have much information. And you have to build
> query on your own. Make new datasourse for each aspect of an?lisis.
> It is month income/expense report on the picture attached.
>
>
> El El dom, 8 sept 2019 a las 13:46, nilay khatri
> <[hidden email] <mailto:[hidden email]>> escribi?:
>
>     Use Google sheet as intermediate data house.
>
>     On Fri, Sep 6, 2019, 4:50 PM socialboostdk
>     <[hidden email] <mailto:[hidden email]>> wrote:
>
>         Hi there,
>
>         Does anyone have experience with connecting?VTiger to Google
>         Data Studio?
>
>         There is as an example a MySQL option, but JSON as an example.
>
>         Thanks :)
>
>
>         _______________________________________________
>         http://www.vtiger.com/
>
>     _______________________________________________
>     http://www.vtiger.com/
>
> --
> --
> ? ?????????, ???????????? ???-?????? PIN
> ??????? ????.
> +7-921-922-91-91
>
> http://pinstudio.ru <http://pinstudio.ru/>
> - ???????? ? ??????????? ??????
> - ????????????? ???????
> - ?????????? ??????
>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20190908/0c6f46b4/attachment-0001.html>

------------------------------

_______________________________________________
vtigercrm-developers mailing list
[hidden email]
http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers


End of vtigercrm-developers Digest, Vol 164, Issue 5
****************************************************

_______________________________________________
http://www.vtiger.com/
Reply | Threaded
Open this post in threaded view
|

Re: Vtiger & Google Data Studio

Alan Lord (News)
Very cool.

I started to develop some "initialisation" code that would automatically
build the necessary tables and meta data in Metabase for a vtiger
installation but then kind of lost interest in it.

Seeing a live demo of something useful might well just inspire me to get
cracking again :-)

Al


On 09/09/2019 13:11, Luke Carazzo wrote:
> I use Metabase as well. I create and report and then print the query and then use the query to manipulate a report and dashboard in Metabase. I have dashboards for all my modules.
>
> Below is a link for tickets or I call it job cards and I manage the progress of Job cards etc.
>
> http://www.imagine-ts.co.za:3000/public/dashboard/7c4f3cd1-2fc1-4656-a001-1a80e7f95093
>


_______________________________________________
http://www.vtiger.com/