I had assumed that Data Point used a specific SQL dialect other than T-SQL, like Oracle PL/SQL, but my friend at work tells me that it depends on which database connection is made in the navigation manager. For example, if I connect to an SAP Hana database, then I should use the SAP Hana dialect of SQL. On the other hand, if I connect to a Microsoft DB, then I should use the T-SQL dialect. Is that correct? As someone coming from SSMS T-SQL, I have a hard time grasping how Toad Data Point has the flexibility to know' which SQL dialect is required, and have the flexibility to adjust accordingly .
Hi - part of the work we do when we create specific connectors to database sources is to add that specific syntax to our editor.