Once the Register Server dialog appears for a PostgresSQL server, provide the following details for the server settings.
Aqua data studio queury analyser how to#
See the official Aqua Data Studio documentation for instructions on how to launch the Register Server dialog and register the server. Register the serverĪfter installing Aqua Data Studio, you must first register the server. Please contact your organization administrator if you do not currently have access to the Queries workspace. To acquire the necessary credentials for connecting Aqua Data Studio to Experience Platform, you must have access to the Queries workspace in the Platform UI. There may be minor discrepancies in the UI between the versions. Screenshots in this guide were taken using the macOS desktop app.
Aqua data studio queury analyser windows#
The default font used by ADS does not support all character sets, so if you need support for Japanese, Chinese and other languages you might need to change your font by selecting File > Options > General >Appearance and select an appropriate font.There are Windows and macOS versions of Aqua Data Studio. The bundled JRE which comes with ADS is the International version, but if you are using your own check if it supports International character sets. Unicode/Character sets - ADS supports Unicode and International character sets, however, you have to verify you are using the international JRE and that ADS is using a font that supports the character set you are using.
Aqua Data Studio also allows saving result sets into different encoding types. When opening a SQL Script, select the ’File Type’ with the appropriate encoding. Īqua Data Studio supports SQL Scripts encoded in different encoding formats. Abbreviations are set within File > Options > Editors > SQL Editor > Abbreviations. There is a selection of key combinations to trigger the expansion of an abbreviation. An entire block of SQL commands can be inserted with a few keystrokes. User-defined abbreviations, created within the SQL Editor Options, work as customizable auto-completion strings. Although the query window will intelligently decide when to popup options, you may activate the auto-completion feature with the CTRL+Space shortcut.
It determines when to popup tables or columns according to the cursor position in the SQL statement at the time of popup. The Query Analyzer provides auto-completion popups for tables, views, synonyms, and their columns. If you do not separate your statements, Aqua Data Studio will not be able to identify your current statement or separate them for script execution. Executing as a script will also generate errors from the RDBMS, unabling it to understand your statement. If you try to use it as a separator Aqua Data Studio will not be able to identify your current statement and will give you the impression that Auto-Completion and other features do not work. Therefore, it keeps the parser fast and simple for Auto-Completion. The reason Aqua Data Studio does not use " " as a separator for SQL statements is because PL/SQL and T-SQL may contain " ". If you omit this, Aqua Data Studio will not perform effectively.ĭO NOT separate your statements with a semicolon " " This allows Aqua Data Studio to quickly identify which statement you are working on so that it may intelligently provide Auto-Completion, Describe, SQL Template, and Execute as a script on the current statement. To use all of the Query Analyzer functionalities you need to separate your SQL statements by using ¨GO¨ or ¨/¨.
Scripts and SQL Statement Separators: Only use GO or / You can change the database you are analyzing in the drop-down menu above the edit window. The toolbar allows you to create a new query, open scripts, save scripts, save results, copy content, cut content, paste content, undo, redo, find, replace, change case, parse, execute, execute current, execute edit, execute explain, stop execution, auto-commit, commit, rollback, reconnect, enable auto-completion, refresh the auto schema, run a parameterized script, and set the maximum results displayed. Click here for a diagram of the toolbar button functions
0 kommentar(er)
