database connectivity - QueryStorm

Screenshots: 0 ...

Features: QueryStorm supports connecting to external databases including SQL Server, PosgreSQL, MySQL, Oracle, DB2, SQLite and Access. When connecting, you select which Excel tables will be visible ... and vice versa. Connecting to external databases Weight:  0 Querying Excel tables alongside permanent database tables. Weight:  0 ... to the database in the form of temp tables. This feature enables users to more easily move live data between Excel and databases, and to query them together. It makes Excel a natural extension of the database ...

Description: as better database connectivity. QueryStorm makes moving data between Excel and databases much easier. As soon as you connect, Excel tables are visible to the database (as temp tables). QueryStorm Features ...

Release Notes: A new type of script for connecting to Oracle databases has been added. Oracle SQL scripts can be created from the QueryStorm ribbon and the project context menu. Excel tables can be made visible ... to these scripts as private temp tables. Fixed issue with the script "connect" dialog which prevented configuring list of tables that should be visible to the script. Minor UI improvements to script ... "connect" dialog. Fixed templates that generate C# codebehind for SQL scripts. 0 ...

Screenshots: 0 ...

Release Notes: for per-machine installation (requires admin rights). This improves initial startup time for C# scripts and code files. Enabled resizing certain tool windows (e.g. log viewer, connect dialog, etc...). ...

Release Notes: and user apps. Fixes The Runtime will no longer crash after an Excel file has been opened in the Windows Explorer's Preview pane. QueryStorm apps will connect to the correct instance of Excel (not ...

Release Notes: database into consideration when generating SQL code. This allows it to create accurate and relevant code, tailored to your specific database. Multilingual Prompts- You can write prompts in most human ... languages, even if the language of the prompt doesn't match the language of the database schema. Configuring the copilot- The copilot requires that you configure it with an OpenAI API key. You can enter ...

Release Notes: with the same name was throwing an exception. If the default SQLite connection string was deleted in project.config, trying to create a new SQLite script would fail (it now recreates the default connection ...

Release Notes: Updates C# from 7.1 to 9 and upgrades SQLite to latest version with window functions. 2.5.7923.20438 Updated Sep 10, 2021 Features Added support for configuring SSL in Postgres connection strings. ...

Release Notes: functions (error values, missing values). Installer issue for versions of Excel installed from the windows store. Reorganized confusing connection dialog. ...

Release Notes: connection. In the new version of QueryStorm, each tab is its own independent context. This means you can have e.g. a Microsoft SQL Server connection in one tab, a SQLite connection in another and a C# code ...

Features: With QueryStorm’s SQLite engine, you can work with Excel tables as if they were database tables. Use SQL to clean, query and process live data inside Excel, without the need to import/export data. ...