AnySQL Modeler

AnySQL Modeler is a visual tool that you can use to perform these actions:

• Add objects such as tables, views, and materialized views to the model.
• Select columns to be extracted.
• Create filters to limit result set.
• Configure joins between objects.
• View the model result in the Data Drawer and more.

Every model is identified by its name and description.

For the Microsoft SQL and Oracle databases, you can write or update a SELECT query in the ION query editor mode. You can write complex queries that include elements such as analytical functions, aggregations, and nested queries. For more information, see Data Drawer.