Accessing Anterra Data Warehouse Securely via Power BI

Accessing Anterra Data Warehouse Securely via Power BI

Install the AWS RDS Root CA Certificate

  1. Download the public certificate here.
  2. Right-click on the downloaded certificate in Windows Explorer (rds-ca-2019-root.crt) and choose Install Certificate

  3. Choose Local Machine and click Next
            
  4. Click Yes if prompted by User Access Control

  5. Choose Place all certificates in the following store then choose the Browse button and select the Trusted Root Certification Authorities
  6. Click Finish and the certificate will be installed, and you're now ready to connect securely to your Anterra Data Warehouse from Power BI or SQL Server Management Studio

Access the DB securely without installing the certificate

The installation of the certificate establishes trust between the two systems that are connecting.  Without the certificate the communication is still secure however it's not possible for your system to confirm the system it is connecting to.  To allow the connection to proceed in SQL Server Management Studio (SSMS) use the following steps:
  1. Enter the connection details on the  Connect to Server  dialog as you normally would then click the  Options >>  button
                         
  2. On the  Connection Properties  tab verify  Encrypt connection  is checked then  also  check Trust server certificate then click Connect

    • Related Articles

    • Data Trimming Security Report

      To help clients better understand what end-users see, Anterra has implemented user security audit reports. Reach this area of Anterra’s site by going to Admin, then User Admin, then User Data Trimming Report. This is a Pivot grid allowing clients to ...

    • Troubleshooting Problems Data Sync to AnterraBI

      Some of the common reasons for the anterraDataCenter sync to stop running are as follows: The local or active directory account that is used by Windows Task Scheduler to run the data update has had its password changed. Your ERP system (Sage, ...

    • Anterra Version v25.2 Release Notes

      Anterra Version 25.2 Release Notes Updates to Anterra Pivot Grids These are general updates that apply to most of the grids through every module (Finance, Construction, and Service Management) Setting the Default Date for a Pivot Grid - KB Pivot ...

    • Data Synchronization - Status display in the AnterraBI™ Menu Bar

      Version 25 Release Anterra has added a data synchronization status icon on the AnterraBI menu bar.  The icon is to the left of the Alerts Icon and rotates when your data or your cube is updating: When you click on the icon, you will see the status of ...

    • Creating the Sage Default Financial Statements for Anterra BI Data Integrity Check

      Creating the Sage Default Financial Statements for Anterra BI Data Integrity Check To confirm the data synchronized from your Sage CRE system to Anterra BI, Anterra requires financial statements for the beginning balance sheet, the last closed fiscal ...