Difference between revisions of "Configuring a Data Source"

From Explore Analytics: The Wiki
Jump to navigation Jump to search
Line 12: Line 12:
  
 
'''Data Source Type''' - use this drop-down list to select the type of data source
 
'''Data Source Type''' - use this drop-down list to select the type of data source
 +
 
'''Don't auto-add tables (create an empty data source)''' - you should normally leave this unchecked so that the tables that are part of the data source will be automatically added to the data source definition and available for reporting. This option is useful in special cases, for example if you have a database with hundreds or even thousands of tables and you're really only interested in a few tables. If you use this option, you'll create a data source with no tables, and then add the desired tables one at a time.
 
'''Don't auto-add tables (create an empty data source)''' - you should normally leave this unchecked so that the tables that are part of the data source will be automatically added to the data source definition and available for reporting. This option is useful in special cases, for example if you have a database with hundreds or even thousands of tables and you're really only interested in a few tables. If you use this option, you'll create a data source with no tables, and then add the desired tables one at a time.
  

Revision as of 13:31, 8 March 2016

Introduction

A Data Source defines a source of data, such as a database or an application. The Data Source may be inside your company's private network or in the Cloud.

Adding a New Data Source

A Data Source defines a set of tables for reporting. When you add a new data source, Explore Analytics connect to the data source and obtains information about the available tables. These tables are then available for reporting.

To add a new data source, select "Add a new data source" from the Data menu. The following dialog appears.

Add a new data source.png

Data Source Type - use this drop-down list to select the type of data source

Don't auto-add tables (create an empty data source) - you should normally leave this unchecked so that the tables that are part of the data source will be automatically added to the data source definition and available for reporting. This option is useful in special cases, for example if you have a database with hundreds or even thousands of tables and you're really only interested in a few tables. If you use this option, you'll create a data source with no tables, and then add the desired tables one at a time.

For more information about defining each type of data source, please use a link below:

Configuring an Oracle Data Source

Configuring a MySQL Data Source

Configuring a PostgreSQL Data Source

Configuring a SQL Server Data Source

Configuring a Microsoft Access Data Source

Configuring a ServiceNow Data Source

Configuring a Salesforce.com Data Source

Configuring a Google Cloud SQL Data Source