There are four different methods for connecting data to your AppInsights dashboards, each of which will be discussed in this section of our Getting Started tutorials...
- Web Services
- Database connectors (Amazon RedShift, MySQL, PostgreSQL)
- Spreadsheet data (CSV, Google Sheet)
- Custom API (Push, Fetch)
We have a library of connectors to web services that offer a straightforward and easy method for pulling in key metrics generated by your project or team. (You can find a full list of integrations on our services page).
You’ll want to start by selecting that app tile from the data sources panel. Let’s use our Google Analytics connector as an example. Click on the "Add Widget" button and select the Google Analytics tile.
You’ll immediately be presented with a set of metric categories; select one of these and you’ll be brought to a list of metrics that correspond to this category. Let’s start by selecting the “Visits” category and selecting the “Site Visitors” widget.
Please note: not all integrations will offer unique metric categories. Selecting an app tile might immediately direct you to a list of available metrics across all categories.
Once you’ve selected your metric of choice, you will be prompted to select a visual output (or visualization) for the data -- let’s select the AppInsights line graph visualization. As soon as you’ve made this selection you’ll notice that a widget has been dropped on your dashboard with a gray gear icon in the center -- this means you have not yet provided your credentials for the connected web service, or that you have not yet confirmed which of your connected accounts you would like to use to populate your widget (if you have two separate Google Analytics accounts, for example).
To connect your Google Analytics account, hover over the un-populated widget and you will be invited to “configure this widget”. You can either select the gray gear icon at top right of the widget and select the “Edit Widget Settings” menu, or you can click the linked text to hop directly to this menu.
When connecting an account for the first time, you’ll notice that the “Authentication” window will automatically suggest that you add one. Click the blue “Connect” button to initiate this process.
Please note: there are two different workflows for connecting your web service data to your AppInsights dashboards. You will either be prompted to enter your standard login credentials -- the same username / password you would use to access this service directly (OAUTH) -- or you will be prompted to enter the API key that corresponds to your account.
While the OAUTH flow will be very similar from one service to the next, the process of finding your API key will differ depending on the service you’re connecting to AppInsights.
Once you've entered your Google Analytics credentials, the fields and filters within the "Edit Widget Settings" menu will fill with their default settings. To finish this step, simply hit the blue "Save" button and your widget will begin pulling data...
At any time, you can re-enter the “Edit Widget Settings” menu to modify the structure of the data being retrieved by the widget (“Data Settings” tab), as well as the format of the visualization you’ve chosen to represent the data (“Widget Settings” tab). Once you’ve made the desired changes to your data and widget settings, just be sure to hit the blue “Save” button to return to your dashboard and view your modified widget.
For those users that would like to run direct SQL queries against a database instance, we currently offer several DB connectivity options: Amazon RedShift, MySQL, and PostgreSQL. To leverage these tools, Click on the "Add Widget" button and -- for MySQL or PostgreSQL -- select the “Databases” tile and then select the format of the data you’ll be retrieving. Amazon RedShift has a tile of its own within our services panel, with similar data format options.
Data Sources - Creating MySQL, PostgreSQL, Amazon Redshift Connections
>>CSV Upload Tool -- For many companies, interactions with company data and KPIs have been reserved to carefully prepared Excel spreadsheets and graphs. While the purpose of AppInsights is to provide your team with live, dynamically updating dashboards...we don’t want to invalidate any strong internal processes you’ve designed around spreadsheet creation.
For these reasons, we’ve designed a tool that will allow you to upload spreadsheet data for representation within AppInsights as long as it is properly formatted to cooperate with our visualizations. To get started, navigate to the “My Custom Data” tile and populate the dashboard with the visualizations you would like to use. Once you’ve properly formatted you data, you can drag your CSV file to our “Upload Spreadsheet” pane (screenshots below).
For a full step-by-step guide, check out our CSV Upload Tool tutorial.
>>Google Sheet integration -- If you’re interested in taking your spreadsheet data one step further, you’ll want to check out our Google Sheet integration. While our CSV Upload Tool requires a fresh upload of data whenever you’d like your visualizations to update, our Google Sheet Integration will allow you to maintain all of your data in an online spreadsheet -- anytime you modify the data points or data sets on this sheet, the changes will automatically be reflected in your connected AppInsights widgets.
To get started, navigate to the Google Spreadsheet tile in our Services pane. You can then select the data format and corresponding visualizations you would like to use to represent your data.
For a full step-by-step guide, check out our tutorial on creating a Google Sheets dashboard.
>>Push & Fetch data tools -- For users with a high level of technical aptitude that plan to represent large amounts of custom data within AppInsights, we recommend our custom Push or Fetch data tools. As long as the necessary infrastructure is in place to host your scripts, you can push or pull data into your AppInsights visualizations as quickly as every 10 seconds.
Similar to using our CSV Upload Tool, you’ll want to start by populating the dashboard with the visualizations you would like to use to represent your data. From there, you can enter the “Edit Widget Settings” menu for each of the visualizations on your dashboard to find the corresponding Access Key and Stream Name identifiers.
For more information, you’ll want to read our comprehensive API documentation which includes information on all of the supported packages and libraries. You can also check out our step-by-step tutorials for both the Push and Fetch data tools:
API: Push Data to AppInsights Widgets
API: Fetch Data From a Custom Source