Home / Documentation / How-to videos
Eight short screencasts were recorded for Caché Monitor. They are still online on YouTube. This page links to them instead of embedding them, so no data is sent to YouTube until you click a link.
- 1How to: register a server
Add a Caché server to the Server Navigator with host, port and credentials and browse its namespaces.
- 2How to: use the editor and execute selected SQL statements
Open the Query Analyzer on a namespace, write a query, execute the whole script, the statement at the cursor or a selection.
- 3How to: register servers from locally known Caché servers
Import the Caché servers already registered on your machine (Caché Server Manager and ODBC data sources) instead of typing them in.
- 4How to: work with the Scripts Manager
Organise SQL script libraries, preview files quickly and open them in the editor.
- 5Write SQL queries across databases
Shows how Caché Monitor helps to query and bring together tables from different sources. Writing a SQL query across namespaces, databases and JDBC sources like Microsoft SQL Server is easy with Caché Monitor, and all of it works without any installation or configuration on the server side.
- 6Work with CSV files like database tables
Join, merge and combine multiple CSV files via SQL. Analyse and filter your CSV files like any other database table.
- 7How to: connect to MySQL on Amazon Web Services
Connect to a MySQL database on AWS with Caché Monitor. You see how to identify and configure the JDBC connection string.
- 8How to: query data from three servers in one SQL statement
Query a Microsoft SQL Server and two InterSystems Caché servers in one SQL statement. The example joins five tables: three from the AdventureWorks database and one table on each Caché server, using the SQL Server linked server feature.
Current tutorials. The features shown here (Navigator, SQL editor, Script manager, Query Cloud, CSV connections) are documented for the current product in the SQL DATA LENS user guide and on the Query Cloud page.
Frequently asked questions
Are the videos still available?
Yes. All eight videos are online on YouTube. To respect your privacy this page does not embed them; each link opens YouTube directly.
Are there videos for SQL DATA LENS?
Current tutorials and feature walkthroughs are published on sqldatalens.com and in the SQL DATA LENS user guide.
Continue with SQL DATA LENS
SQL DATA LENS is the current release of this tool: native InterSystems IRIS and Caché support, SQL editor, Global Browser, database diagrams, Query Cloud and much more. Free Edition and a full 30-day Pro trial with every download, no registration.