Toad Data Point 6.1 - User Guide

Chat now with support

Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

About Business Intelligence and NoSQL Data Sources

Note: This feature is available in the Toad Data Point Professional Edition only.

Toad provides users with the ability to create connections to non-traditional data sources, such as NoSQL and Business Intelligence data sources. These connections are different than traditional database connections.

In most cases, when connecting to these non-traditional data sources, the user is accessing data through an exposed presentation layer rather than connecting to the underlying database objects. The look and organization of data in the exposed layer is different than in a typical relational database and varies depending on the data source.

Toad supports the following data sources:

Business Intelligence

NoSQL

Using Business Intelligence and NoSQL Data Sources

You will find that you can use much of the functionality in Toad to explore data objects, to query data, to report results, and to automate workflows from these non-traditional data sources, with some exceptions. Review the following special considerations before using these data sources.

Considerations and Limitations - All Data Sources (Except Impala)

The following apply to all Business Intelligence and NoSQL connections except Cloudera Impala.

Consideration / Limitation	Description
Mapping data source objects	When you create a new connection to a Business Intelligence or NoSQL data source, Toad automatically maps the data source objects. Toad gathers metadata from these objects which is cached (in a hidden table) and retained between sessions for one week. After one week, all objects are automatically remapped. Exception: For Hive connections, cached metadata is retained until manually refreshed. Note: To manually refresh the metadata, right-click an object in the Object Explorer and select Refresh All. During the initial mapping process, Toad maps only metadata. The actual data is mapped as needed, such as when you execute a query.
Organization of objects	When you view the objects in a NoSQL or Business Intelligence data source (in the Database Explorer for example), the organization may be slightly different than a traditional database and will vary depending on the type of connection.
Code-completion list	The code completion treelist reflects the organization of the exposed objects in the data source, and presents the objects you will want to use to compose a query. However, the treelist may look slightly different than what you would expect to see for a traditional database connection.
Composing cross-connection queries	The fully-qualified name format used for NoSQL or Business Intelligence connections in a cross-connection query statement is different than that used for traditional database connections, and varies depending on the type of connection.
Delay when executing query	Because columns and data are mapped as needed, this may cause you to experience a slight delay when performing tasks such as executing a query or viewing columns and data in the Database Explorer.
Filtering in Database Explorer	The Filtering function in the Database Explorer is disabled for all NoSQL or Business Intelligence data source connections.
Data Compare	Data Compare is not available for NoSQL or Business Intelligence connections.
Read-only	NoSQL or Business Intelligence connections in Toad are read-only. You cannot create or alter data source objects (except objects created and stored in Toad, e.g., Analysis Services Queries). You cannot import data to NoSQL or Business Intelligence data sources using Toad.