In this tutorial, you will discover how to establish connections to various data sources within Toad Data Studio. You will see how to work with the Navigation Manager to create, view and manage your connections. Supported data sources include:

File Data Sources: CSV file, MS Access and MS Excel

Relational Data Sources: Amazon Redshift, Greenplum, IBM DB2 iSeries, IBM DB2 LUW, IBM DB2 z/OS, IBM Netezza, MariaDB, MS SQL Azure, MS SQL Server, MySQL. ODBC Generic, Oracle, PostgreSQL, SAP ASE, SAP HANA, SAP SQL Anywhere, Snowflake, Teradata and Vertica

Business Intelligence Data Sources: Generic OData, Google Analytics, MS SQL Server Analysis Services, Oracle BI Enterprise, Salesforce, SAP Business Objects and SharePoint

NoSQL Data Sources: Amazon DynamoDB, Apache Cassandra, Apache HBase, Apache Hive, Cloudera Hive, MS Azure Table Services and MongoDB

Have questions, comments? 

Head over to the Toad Data Studio forum on Toad World®!  Chat with Toad developers, and lots of experienced users.

Start the discussion at