AppCenter can be used as a visualizations platform to render the visualization JSON objects that are generated by the Visualizer SQL-MR function. In this setup, AppCenter is not used as a portal, and users are not required to log into AppCenter to view the visualizations. This setup requires installing AppCenter, and configuring it with a connection to the Aster Cluster, and then running theVisualizer SQL-MR function on the Aster cluster (which can be done from the command line or from a BI tool) with the URL option enabled.

The Visualizer function will then produce a URL that can be:

Manually copied and pasted into a web browser for displaying the data visualization.

OR

Stored in a table that is displayed in a Standard BI tool dashboard. This option is convenient for BI tool users, because they are presented with a live, clickable URL for displaying the visualization in the default browser window.

The URL predicate will tell Aster to run this statement against the Aster AppCenter instance located at the IP address and port number. Your port number might be different based on your configuration. The IP address noted above is for AppCenter on Aster Express 6.10. The profile=AE tells AppCenter what connection information that was set up in Aster AppCenter. Basically this is a JDBC/ODBC connection to the Aster Cluster that this statement will run against. The output=viz tells the Visualizer statement what table to place your new visualization (the table we just created).

When you run the above statement and then do a SELECT * FROM public.viz limit 100; you will get the URL you created: