Intelligent Object Connector for Compass

Data from Compass can be loaded into Nitro using an Intelligent Object Connector, which is a type of Industry Data Connector, and predefined allow lists, which replace table definition files. The following allow lists are provided for Compass for use with the Intelligent Object connector:

  • Compass Prescriber
  • Prescriber & Zip
  • Compass National
  • National & State
  • Compass Patient
  • Patient

When users run a query in Compass and select Send to Nitro, the required tables are automatically created in Nitro with the query name appended to the table name. Only one set of allow lists is needed for multiple Compass queries. For example, a prescriber query named “Bacterial Conjunctivitis” results in the following tables:

  • prescriber_bacterial_conjunctivitis__v
  • prescriber_rcrd_cnts_bacterial_conjunctivitis__v

To create an Intelligent Object connector for Compass:

  1. Log into the NAC.

  2. Select Inbound Connectors from the Connectors section of the side menu.

  3. Select the New Connector button.

  4. Add connector details including display name and description.

  5. Select Compass as the connector type under Intelligent Objects.

  6. Select Save.

  7. Create a support ticket for Nitro to set up the Compass S3 Copy.

  8. Create a connector user in the NAC specific for this connector. This user will allow you to log into the SFTP site.

To load data to Compass:

  1. Run a query in Compass then select Send to Nitro. In Nitro, The query is copied into all Compass Intelligent Object Connectors and loaded automatically.

  2. Log into the NAC.

  3. Run the Compass S3 Copy to Nitro job.

  4. When the job is complete, run the Data Lake Intelligent Load job.

To access the data once the job completes, users must view the Report Current or Report History schema using a BI tool, for example, Nitro Explorer.