The PEARS data mart can be used in combination with Power BI as follows. Prerequisites Setup Power BI can connect directly to the data mart using the PostgreSQL provider, npgsql. This provider and its necessary drivers are installed with Power BI Desktop and Power BI Gateway. However, before a trusted connection can be established with … Read more
The PEARS data mart can be used in combination with R and RStudio as follows. Prerequisites Setup Certificates Before a trusted connection can be established with the data mart, Amazon’s RDS certificates must be downloaded to a local folder on the device. Package Installation R can connect directly to the data mart using the RPostgres … Read more
The PEARS data mart is a read-only nightly copy of the entire set of PEARS data for your organization(s), transformed into a more readable and usable database schema. You can connect directly to your data mart database using tools like TablePlus (TablePlus | Modern, Native Tool for Database Management.) or Power BI. Or, you can … Read more