---
title: Access Data Outside Enterprise using SQL
description: Use AWS Athena to connect to the data and visualize it in your preferred solution
---

[Skip to content](https://help.enterprisemanager.io/access-data-outside-enterprise-using-sql#main-content)

English

Show submenu for translations

IDEXX Enterprise

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- Go to info.enterprisemanager.io

 Go to info.enterprisemanager.io

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.enterprisemanager.io/?hsLang=en)
2. [Analytics](https://help.enterprisemanager.io/analytics?hsLang=en)
3. [Analytics "How Tos"](https://help.enterprisemanager.io/analytics?hsLang=en#analytics-how-tos)

# Access Data Outside Enterprise using SQL

## Use AWS Athena to connect to the data and visualize it in your preferred solution

Enterprise allows you to create reports and dashboards leveraging the models built to bring the data together in insightful ways to drive growth. We understand that sometimes accessing the data directly to pull into your current business processes and visualization tools is the preferred solution.

Accessing data outside IDEXX Enterprise is simple. We provide you with multiple ways to integrate your data into existing data visualization tools or business processes. Below is a quick snapshot of the most popular options:

- [Send Scheduled Reports in Email in supported formats](https://help.enterprisemanager.io/send-or-schedule-a-saved-look?hsLang=en)
- SQL Access through AWS Athena and AWS S3

The second option requires a bit of technical finesse but can be obtained by the steps outlined below. Note that not all reports will successfully be able to execute through Analytics and, by extension, a S3 scheduled export. Validation through testing is the best way to secure a workable export. Keep the exports limited to the data that is needed for optimal performance.

Follow the steps below to schedule an export that is accessible using SQL to query data.

1. Create an AWS S3 Bucket (see [How do I create an S3 bucket?](https://docs.aws.amazon.com/AmazonS3/latest/user-guide/create-bucket.html))
2. Add a folder in the S3 Bucket for csv files and the processed file, which is used by Athena for running queries, for example:

3\. Send saved Look to S3 through either a one time send, or a scheduled send (Recommended: send a test before scheduling to ensure success and be sure to specify the correct output path, such as 'csv' like the example above)

<iframe data-hsv-src="https://play.hubspotvideo.com/v/9204302/id/76478971948" referrerpolicy="origin" sandbox="allow-forms allow-scripts allow-same-origin allow-popups" allow="autoplay; fullscreen;" style="position: absolute !important; width: 100% !important; height: 100% !important; left: 0; top: 0; border: 0 none; pointer-events: initial" title="HubSpot Video" loading="lazy" data-hsv-id="76478971948" data-hsv-style="" data-hsv-width="688" data-hsv-height="373" data-hsv-autoplay="false" data-hsv-loop="false" data-hsv-muted="false" data-hsv-hidden-controls="false" data-hsv-full-width="false"></iframe>

4\. Set up AWS Glue to automatically crawl the S3 bucket and create a schema for use in Athena

5\. Run the new crawler created in step 4

6\. Once the crawler has completed, test a query through Athena query tool (See step 3 in [Getting Started](https://docs.aws.amazon.com/athena/latest/ug/getting-started.html))

7\. Connect Athena Database to [Tableau](https://help.tableau.com/current/pro/desktop/en-us/examples_amazonathena.htm) or other preferred visualization tool

- [Reset your Password](https://help.enterprisemanager.io/reset-your-password?hsLang=en)
- [Sign Up](https://help.enterprisemanager.io/sign-up?hsLang=en)
- [Key Metrics Overview](https://help.enterprisemanager.io/key-metrics-overview?hsLang=en)
- [Analytics](https://help.enterprisemanager.io/analytics?hsLang=en#main-content)

    - [Analytics Dashboard/Report Descriptions](https://help.enterprisemanager.io/analytics?hsLang=en#analytics-dashboard-report-descriptions)
    - [Analytics "How Tos"](https://help.enterprisemanager.io/analytics?hsLang=en#analytics-how-tos)
    - [Product Offerings](https://help.enterprisemanager.io/analytics?hsLang=en#product-offerings)
- [Control Center](https://help.enterprisemanager.io/control-center?hsLang=en#main-content)

    - [Search for Invoice Items](https://help.enterprisemanager.io/control-center?hsLang=en#search-for-invoice-items)
    - [Managing Invoice Items](https://help.enterprisemanager.io/control-center?hsLang=en#managing-invoice-items)
    - [Bulk Changes](https://help.enterprisemanager.io/control-center?hsLang=en#bulk-changes)
    - [History](https://help.enterprisemanager.io/control-center?hsLang=en#history)
- [Practice Connections](https://help.enterprisemanager.io/practice-connections?hsLang=en)
- [User Management](https://help.enterprisemanager.io/user-management?hsLang=en)
- [Frequently Asked Questions](https://help.enterprisemanager.io/frequently-asked-questions?hsLang=en)
- [Help & Support](https://help.enterprisemanager.io/help-support?hsLang=en)
- [Release Notes](https://help.enterprisemanager.io/release-notes?hsLang=en)

# IDEXX Enterprise

enterprisemanager.io Help Center

Copyright © 2026, IDEXX Enterprise

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://9204302.fs1.hubspotusercontent-na1.net/hubfs/9204302/access%20data%20outside%20Enterprise.mp4",
  "dateModified" : "2022-06-15T14:34:08.110Z",
  "duration" : "PT25.195S",
  "height" : 1040,
  "name" : "access data outside Enterprise",
  "thumbnailUrl" : "https://9204302.fs1.hubspotusercontent-na1.net/hubfs/9204302/access%20data%20outside%20Enterprise.mp4/medium.jpg",
  "uploadDate" : "2022-06-15T14:34:04.521Z",
  "width" : 1920
}
```