They should immediately run and return data. Charts are also generic, for real-time analytics with regular charts.Дouble-click now on any of these demo queries.Inline Charts are also generic, for charts painted in gridвЂ™s cells.Basic queries are generic, with on-the-fly data generated with UNION operators.A popup opens up with all sorts of demo queries that can be automatically generated for you. In Data Xtractor, Visual Xtractor or Query Xtractor, expand the Queries вЂ“ Demo Queries folder, and click on add demo queries. managers вЂ“ database view with each employeeвЂ™s managerвЂ™s name.datatypes вЂ“ specific database table for each RDBMS, to test supported data types.proj вЂ“ database table with employee projects.

emp вЂ“ database table with employees and reflexive relationship to the manager.

dept вЂ“ table with departments and one-to-many relationship to employees.

For EmployeesQX, here is a modified Detailed Model: Several ER model diagrams are automatically generated once you establish a connection with any database. The script files can be also downloaded from GitHub. We use it internally for testing, but we also included all setup SQL scripts in our product distributions. They are installed by default in the C:/Program Files (x86)/XtractPro//samples setup folder, and replicated to your C:/Users//AppData/Local/Xtractor/samples user directory.Д®mployeesQX is a very small database, inspired from a sample used by Oracle for many years. All our products include SQL scripts and database files for the Employees sample, for all supported database types.

Mysql load sample database workbench