Developing Workbooks for the FICO Analytic Cloud
When developing a workbook that will be deployed into the FICO Analytic Cloud the view developer must be aware that the mirror database on the cloud is a MySQL database and not a PostgreSQL database, as supplied in the on premise version of Xpress Insight.
When the workbook is published to the Tableau server through
Xpress Insight, the
Xpress Insight server will perform some simple transformations on the workbook data sources. Due to feature differences between PostgreSQL and MySQL and also differences in the definition of Tableau data sources between Tableau versions, workbooks will be rejected by
Xpress Insight if one or more of the following conditions occur:
- The Tableau workbook was created using Tableau 8.1.x or earlier.
- One or more of the data sources in the workbook contains a FULL OUTER join.
Warnings will also be displayed if one or more of the following conditions occur:
- One or more of the data sources in the workbook uses custom SQL. Xpress Insight cannot guarantee that this SQL will run correctly against a MySQL database.
- The workbook uses RAWSQL_ or RAWSQLAGG_ Tableau functions. These can contain SQL. Xpress Insight cannot guarantee that the SQL contained in these will run correctly against a MySQL database.
It is advised that custom SQL data sources, RAWSQL_ and RAWSQLAGG_ Tableau functions are not used in workbooks that are to be published to the cloud.