This is similar to the above example where all schemas, except the XXPKD schema, are excluded. The filter shown below is set to exclude all databases except those that start with "aq". Also note that the filter pattern is case sensitive. Note the "+" in front of the XXPKD pattern. If your intention is to show only the tables that start with XXPKD, then you'll need to change your main filter to "Exclude All", and secondary filter to "+XXPKD*". Using the dropdown at the top of the Filter Tab, quickly change your Schema or Folder View. The user can define filters for each of the Tables, Views, etc. Object Folder filter works on individual folders inside a particular database. Example folders: Tables, View, Procedures, etc. Reconnect to see the changes.įilter Databases works on the list of databases inside the "Databases" folder.įilter Folders works on the list of folders inside a particular database. Use options to INCLUDE or EXCLUDE all Schemas and Folders.Įnter the Schema or Folder name in the specified text area and Press OK. ![]() Sometimes you would like to view only specific Schemas. Default Folders are Tables, System Tables, Views, Indexes, Triggers, Procedures, Functions. You can Create, Edit or Delete Object Folders. Exclude Objects: A list of objects to exclude after the main filter is applied.Include Objects: A list of objects to include after the main filter is applied.Filter Objects: Allows the user to specify the main schema browser filter for object types, on whether to include or exlude all.Exclude Databases/Schemas: A list of databases/schemas to exclude after the main filter is applied.Include Databases/Schemas: A list of databases/schemas to include after the main filter is applied.Filter Databases/Schemas: Allows the user to specify the main schema browser filter for databases or schemas, on whether to include or exlude all.Go to the Filters Tab and make changes in the Options. Using Filters Options in Registration (Filters Tab)Įdit the Server Properties, to use FILTER options for a Server in Aqua Data Studio: Using the Keyboard combination "CTRL + SHIFT + P", you may quickly access Server Properties and edit Tab Coloring options. ![]() Right Click on the Server - A Popup Menu AppearsĬlick on the Item which displays Server Properties.īased on the Server Type, you can edit the Tab Coloring option to identify your environments. To Identify Server Environments, whether it is a Production, Development or Test, use Tab Coloring feature : How to Install the Java JDBC-ODBC Bridge Driver.Using Advanced Properties (Advanced Tab).Using Filters Options in Registration (Filters Tab).Aqua Data Studio can run using Java 1.8 and still use the JDBC-ODBC bridge from Java 1.7 if Java 1.7 is added to the installation. See How to Install the JDBC-ODBC Bridge Driver for installation instructions. The driver is not bundled with Aqua Data Studio which could cause a missing driver error. Oracle has removed the JDBC-ODBC bridge driver in Java 1.8. When registering a Generic-ODBC connection make sure that an ODBC datasource has already been created for use.Īqua Data Studio version 17 uses Java 1.8. When registering a server using the Generic-ODBC connection type, make sure you specify the location of the driver which you will be using, with the correct URL and driver name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |