A Visual Studio Code extension that adds Netezza database support to SQLTools.
Features
- Connect to Netezza databases
- Execute SQL queries
- Browse database schemas, tables, views, and columns
- Autocomplete for database objects
- View table data
- Format SQL queries
Installation
- Install SQLTools extension
- Install this Netezza driver extension
- Reload VS Code
Requirements
- SQLTools extension installed
- Access to a Netezza database
- Netezza database server running and accessible
Configuration
Create a new SQLTools connection with the following parameters:
- Connection Method: Server and Port
- Server Address: Your Netezza server hostname or IP address
- Port: Default is 5480
- Database: The database name to connect to
- Username: Your Netezza username
- Password: Your Netezza password
- Secure Connection: Enable SSL/TLS connection (optional)
Example Connection Settings
{
"name": "Netezza Production",
"driver": "Netezza",
"server": "netezza.example.com",
"port": 5480,
"database": "mydb",
"username": "admin",
"password": "password",
"netezzaOptions": {
"secureConnection": false,
"queryTimeout": 30
}
}
Usage
- Open the SQLTools sidebar in VS Code
- Click "Add New Connection"
- Select "Netezza" as the driver
- Fill in your connection details
- Click "Test Connection" to verify
- Click "Save Connection"
- Connect to your database and start querying!
Supported Features
- ✅ Connection management
- ✅ Query execution
- ✅ Database browsing
- ✅ Schema browsing
- ✅ Table browsing
- ✅ View browsing
- ✅ Column browsing
- ✅ Table data preview
- ✅ Query history
- ✅ Generate CREATE script (right-click on table/view)
- ✅ SSL/TLS connections
- ✅ Configurable query timeout
Known Issues
Please report issues on the GitHub repository.
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
MIT
Credits
This driver uses node-netezza to connect to Netezza databases.
Built for use with SQLTools.
