Connecting Omnis Studio to SAP ASE via ODBC Driver

When using ODBC Driver for SAP Sybase Adaptive Server Enterprise in Omnis Studio as a data source, Omnis Studio does not display tables and other objects from dbo schema (it considers them as system ones). To solve the issue, do the following:

1. After creating a session using Session Manager, in the SQL Browser tab, click Options.

   

2. In the opened dialog, check Include System objects and click Save.

   

In this case, all the required tables and objects will be displayed by Omnis Studio.