Toad Data Studio 1.1

Chat now with support

Create Amazon Redshift Connections 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

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

Create SAP Connections

You can create a new SAP IQ, SAP SQL Anywhere, or SAP ASE connection, or connect to an existing connection from the Create New Connection window. See Troubleshoot SAP Issues for more information about troubleshooting connection issues.

Click here to view a video about creating connections in Toad Data Studio

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create an SAP connection

Click on the toolbar (ALT+F+N).
Select SAP ASE, SAP IQ, or SAP SQL Anywhere from the Group list.

Enter the login information. Review the following for additional information:

Login Tab	Description
Host	Enter the host name for the connection. Note: This field is only available when you select an SAP IQ or SAP SQL Anywhere connection.
Port	Enter the number of port.
Password	Enter the password to use when connecting. Tip: After connecting, you can set a master password to further secure your connection in Tools \| Options\| Environment \| Security.
CharSet	Enter the client character set such as UTF-8 in this field if it differs from the default character set. This helps you avoid connection issues. Notes: This field is not case sensitive. This field is only available when you select an SAP ASE connection.
Category	Select or create a category if you want to color code Editor tabs for a specific connection. This can help differentiate between development and production databases. You can also set an option to color code the Object Explorer pane and object editor windows (Create, Alter, Drop, etc.). See Set Connection Categories for more information.
Options Tab	Description
Language	(SAP ASE only) Set language for your connection to SAP ASE to override your Region \| Format settings in Control Panel. If the field is left empty the default language is used. Default is us_english.
Kerberos	Select whether you want to use Kerberos when connecting. Default is No.
Encryption	Select None if you do not want to use encryption during connecting. Select TLS to use the highest available encryption when connecting. Indicate the path to your certificate file if you want to use TLS encryption.
Advanced Tab	Description
ODBC driver	Select an ODBC driver to use for this connection when creating cross-connection queries. Tip: You can specify the ODBC driver to use for all connections for this database provider in Tools \| Options \| Database \| Oracle.

Click Connect to save the connection and immediately connect to the database.

or

Click Save to save the connection without connecting to the database.

Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Studio 1.1 - User Guide

Create SAP Connections