sqltools-intersystems-driver


Follow
2
Star
2
Details
Releases
Issues
This application is not supported by InterSystems Corporation. Use it at your own risk.

What's new in this version

Initial Support for InterSystems IRIS in SQLTools extension for VSCode

InterSystems support for SQL in the SQLTools extension to Visual Studio Code

SQLTools Driver for InterSystems IRIS

Overview

InterSystems IRIS makes it easier to build high-performance, machine learning-enabled applications that connect data and application silos.

It provides high performance database management, interoperability, and analytics capabilities, all built-in from the ground up to speed and simplify your most demanding data-intensive applications.

As a complete, cloud-first data platform, InterSystems IRIS eliminates the need to integrate multiple technologies, resulting in less code, fewer system resources, less maintenance, and higher ROI.

Try out the SQL QuickStart and explore more getting started exercises.

Installation

  • Install SQLTools in VS Code from the Marketplace
  • Install the InterSystems extension to SQLTools
    • Install a published version from within VS Code
      • Click on the Extensions icon in your Activity pane
      • Search for SQLTools
      • Find InterSystems and click on Install
    • Or install a beta version
      • Go to the GitHub releases page
      • Expand Assets triangle for the latest version
      • Download the file ending in .vsix
      • Click on the Extensions icon in the Activity pane
      • In the Extensions pane, at the top right, click the "..." menu and select "Install from VSIX..."

Configuration

  • Click the SQLTools icon in the Activity pane (left side of VS Code)
    SQLTools icon in Activity pane
  • Click "Add new connection"
    Add connection button
  • Click InterSystems IRIS
  • Fill out connection information
  • Test the connection
  • Save the connection

Use

With a connection defined, you can now write SQL, browse tables, etc.

To write raw SQL

  • Click the "New SQL file" icon
  • Write your SQL statement
  • Click "Run on active connection"
  • Or, select the SQL statement text, and execute it
    • either right-click and select "Run selected query" from the contentual menu
    • or type Command-E, Command-E (Mac)
    • or type Ctrl-E, Ctrl-E (Windows)

To browse tables

  • Click on your connection
  • Click on "Tables"
  • Right-click on the table of interest
  • From the contextual menu, select "Show table records"
Category
Developer Environment
Works with
InterSystems IRISInterSystems IRIS for HealthCachéEnsemble
Tags
Info
Publisher
CaretDev
Version
0.1.0
Last updated
2020-09-08
Repository
Open
Documentation
Open
License
Link