If you already have a webserver connected to said database, you could set up an URL to return the data you need in a specially formatted JSON format ( See http://code.google.com/apis/chart/interactive/docs/php_example.html ) and have the Google Chart use it.
A more complex alternative might be to have your server expose data as Google Chart Tools-compliant datasource ( http://code.google.com/apis/chart/interactive/docs/dev/implementing_data_source.html). There are helper libraries to simplify the task ( http://code.google.com/apis/chart/interactive/docs/dev/dsl_intro.html) but you should probably go down this road only if the amount / variety of data that you have to expose justifies it. For most simple cases, simply outputting a JSON version of the data from your server and coercing them on the client into the format Google Charts require should be enough. /R. On 26 July 2011 20:24, GerBen <[email protected]> wrote: > Hello Colleagues, > How can I read data from an external database (say, MS SQL Server or > MySQL) and show it in a Google Chart? > Thank you. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
