• 首頁 Home
  • 關於友環 About Linksoft
  • 活動資訊 Events
  • 聯絡我們 Contact Us
  • 註冊
  • 登入
+886-2-2221-2155
[email protected]
0
已加入詢價收藏車: 0筆
  • 產品分類列表
    • 商務工具
    • 應用軟體
    • 開發及程式工具
    • 系統工具
    • 傳輸.遠控.郵件
    • 資訊安全工具
    • 文書處理
    • PDF 應用
    • 網頁相關
    • 圖表編輯
    • 簡報排版
    • 影音軟體
    • 統計分析軟體
    • 數值分析軟體
    • 學術研究軟體
    • 開發及程式工具
      • 商務工具 應用軟體 系統工具 傳輸.遠控.郵件 資訊安全工具 文書處理 PDF 應用 網頁相關 圖表編輯 簡報排版 影音軟體 統計分析軟體 數值分析軟體 學術研究軟體
    • 資料庫開發管理
      • Java & XML 程式碼編輯 程式碼檢查 虛擬裝置 終端機與伺服器 軟體封裝 開發追蹤檢測 ASP 工具 PHP 工具 C++ 工具 日誌分析 電路板設計 開發整合工具 驅動程式開發 OPC 工具 圖表開發程式
    • Active Query Builder 資料庫開發管理軟體
Active Query Builder 資料庫開發管理軟體

本公司皆販售最新版本,目前版本僅供參考
最新版 Active Query Builder WinForms v3.7 更新於 2021/1/2

加入詢價收藏車

直接詢價

  • 產品介紹
  • 特色
  • 版本比較
  • 系統需求
  • 程式截圖

Active Query Builder 是可視化SQL數據庫查詢程式。其允許用戶進行複雜的SQL查詢,數據解析,分析SQL查詢結果與將之可視化。Active SQL Query Builder是一個真正雙向的查詢創建器,因此用戶可以將可視化查詢創建與SQL查詢結果的文本編輯相結合。

Active Query Builder is a full-featured component suite for software developers. It includes:

  • A Visual Query Builder component to design SQL queries via an intuitive visual interface.
  • An SQL Query Parser to build an SQL query object model of any given SQL query.
  • An SQL Text Editor with code completion and syntax highlighting.
  • A highly-customizable SQL Query Text Formatter.
  • A powerful SQL Query Builder API to modify existing and create new SQL queries by the code.
  • A set of components to build feature-rich data browsing UI with data filtration, sorting and pagination.
  • A set of helpers to connect to different databases and execute SQL queries against them.

Usage scenarios

Ad-hoc reporting

  • Let users query your database to get data they need right now.
  • Embed visual query builder into your report system to allow precise data selection for custom reports.

 

Data filtration

  • Let users define filters for database object fields and columns of the given query via handy tree-like control.
  • Change sorting and calculate totals for a given dataset.

 

Data import

  • Connect to external database
  • Build SQL queries to extract data
  • Map query columns to fields of internal database objects for data import


 


Active Query Builder is made for

Developers

  • Enable ad-hoc reporting to business users
  • Provide users with safe access to data
  • Set up dataflow in your application the way you need

 

DB Admins

  • Control data access permissions while querying data at all levels: objects, fields, and records
  • Analyze SQL queries and understand complex structures

 

Database Users

  • Get data in seconds
  • Build queries fast without SQL knowledge
  • Visualise SQL queries and database schema as a diagram

 


Key advantages of Active Query Builder

► Simple and clear visual SQL query building interface
The interface of Active Query Builder is familiar to most database users. Users build queries mostly by mouse clicks and drag'n'drop operations.

Active Query Builder helps users to build SQL queries by giving them advice on object references, keeping away from common errors and warning them about problems. When working with Active Query Builder, the user thinks about the data s/he needs to get, not about the correctness of SQL syntax.

Visual query builder lets users design queries with sub-queries on separate tabs, edit their texts separately from the main query and preview the sub-query results.

► Friendly SQL query building environment
Active Query Builder gives a clear view of your database schema to end users. It helps users find the needed objects and fields, and browse relationships between objects.

Active Query Builder lets you give friendly aliases for objects and fields. It allows you to group objects by subject area, defining favorite objects. With Active Query Builder you can replace real objects with improved versions, add calculated fields, and hide unwanted ones.

► Reverse engineering of even the most complex SQL queries
Active Query Builder can parse SQL queries of any complexity and build visual diagrams. The ability to parse SQL queries allows you to browse them visually, and understand and analyze their structure.

Users can preview the results of subquery execution to get an idea of what data it brings to the main query. They can edit the subquery text separately from the entire query without fear of ruining the whole query.

► Combining Visual Query Building with text editing
Active Query Builder is a true two-way query builder; the end user can switch between visual query building to SQL text editing at any time. Changes made to the query text are applied to the visual diagram and vice versa.

The advanced SQL text editor with code completion and syntax highlighting makes SQL text editing convenient for professional query writers. SQL text formatting lets you touch up SQL query text to improve readability.

► Essential data browsing assistant, easy-to-use SQL Filter Builder
When browsing result query data, users often need to change sorting, apply filters, and calculate totals. These are essential features for building a convenient interface to work with data.

Active Query Builder provides an API and accompanying visual SQL filter builder control to perform these operations on a query. The API also helps build a paginated data browsing interface.

► Flexible metadata management, fast database schema retrieval
Active Query Builder can load database schema from various DB connections and custom data sources. You can define filters for metadata to get rid of unwanted objects or remove them one by one. You can fill database schema by code when working with a custom data source or a web service. The component can work without a live database connection by loading metadata from a pre-generated XML file reducing the database server load and speeding up the component initialization.

► Powerful API to analyze and edit SQL queries
Active Query Builder gives you full control over user queries. It lets you parse SQL queries and get information about used database objects and fields. You can perform in-depth SQL query structure analysis, edit user queries, or create SQL queries from scratch. By analyzing user queries, you can deny the execution of unwanted queries or add necessary conditions to prevent unauthorized access to data.

Active Query Builder shows the list of parameters used in a query, along with information about the fields of database objects to which they are applied.

► Full support of numerous SQL dialects and ANSI SQL standards
Active Query Builder's SQL Parser supports dozens of SQL dialects: Oracle, MS SQL Server, Azure, MySQL (MariaDB), PostgreSQL (Redshift), SQLite, MS Access, InterBase, Firebird, IBM DB2 (incl. AS/400), Informix, SAP IQ, SAP SQL Anywhere, SAP ASE, SAP Hana, SAP Advantage DB, Netezza, Teradata, Pervasive (Actian Zen). It correctly handles the subtleties of each supported SQL dialect. When working with parsed queries, Active Query Builder keeps every single query clause used during the query building process with no losses.

As it's compatible with ANSI SQL/92, SQL/89, and SQL/2003 standards, Active Query Builder works fine with many other ANSI SQL-compatible database servers, such as Vista DB, Nexus, Elevate DB, Vertica, Progress (OpenEdge), Apache Spark, Amazon Aurora, Amazon Athena, Google Big Query, Cassandra, Impala, and more.

► Easy integration into your application
You can embed SQL Query Builder into your application with a few lines of code. The Knowledge Base, documentation and numerous demo projects will help you get acquainted with the component in a few days.

 

WinForms and WPF 

FEATURE STAND. PROF. NON-VIS.
MAIN FEATURES
Visual SQL query builder
YES
YES
NO
Visual designer for building SELECT statements with simple drag'n'drop and point'n'click actions.
Professional SQL Text Editor
NO
YES
N/A *
Feature-rich SQL text editor with code completion and syntax highlighting.
SQL QUERY DESIGNER FEATURES
SQL Expression Editor
NO
YES
N/A *
Handy dialog to edit complex SQL expressions via the multiline text editor with code completion, syntax highlighting and the lookup lists of objects, fields and SQL functions.
QUERY BUILDING ENVIRONMENT CUSTOMIZATION OPTIONS
Decomposable visual user interface
NO
YES
N/A *
Possibility to decompose and customize the user interface by removing, reorganising and adding new visual controls.
Repository of reusable queries
NO
YES
N/A 
A special visual UI snippet lets save and edit SQL queries in the internal repository, with the possibility to use these queries just like views in subsequent queries.

 

Notes

* The Non-visual .NET version doesn't provide any visual user interfaces, it is only for the programmatic use of API.

** The Free version has support only for the most common features of SQL language up to ANSI SQL/92 standard while the paid versions support the great majority of database server-specific SQL syntax extensions for dozens of popular database servers.

 


 ASP.NET

FEATURE STAND. PROF. CORP.
ASP.NET-SPECIFIC FEATURES
Multiple queries per user session
NO
YES
YES
Simultaneous building of different queries in separate browser windows or designing more than one query on a web page.
Storing client state without using ASP.NET session
NO
NO
YES
Unlimited possibilities for configuring the application architecture: containerization, usage in web farms, cross-domain or stateless systems.
QUERY BUILDING ENVIRONMENT CUSTOMIZATION OPTIONS
Editing of sub-query text separately from the entire query
NO
YES
YES
The text of any single sub-query can be accessed and changed independently of the main query.
Repository of reusable queries
NO
YES
YES
A special visual UI snippet lets save and edit SQL queries in the internal repository, with the possibility to use these queries just like views in subsequent queries.
Addition of calcluated fields by user
NO
YES
YES
Advanced users can add new calcluated fields to the database object fields list.

 

Notes

* The Non-visual .NET version doesn't provide any visual user interfaces, it is only for the programmatic use of API.

** The Free version has support only for the most common features of SQL language up to ANSI SQL/92 standard while the paid versions support the great majority of database server-specific SQL syntax extensions for dozens of popular database servers.

 


 VCL

FEATURE STAND. PROF.
MAIN FEATURES
Visual SQL Filter Builder
NO
YES
A visual control to add conditions for the columns of original SQL query appending them to the WHERE clause.
Professional SQL Text Editor
NO
YES
Feature-rich SQL text editor with code completion and syntax highlighting.
SQL QUERY DESIGNER FEATURES
SQL Expression Editor
NO
YES
Handy dialog to edit complex SQL expressions via the multiline text editor with code completion, syntax highlighting and the lookup lists of objects, fields and SQL functions.

 

Notes

* The Non-visual .NET version doesn't provide any visual user interfaces, it is only for the programmatic use of API.

** The Free version has support only for the most common features of SQL language up to ANSI SQL/92 standard while the paid versions support the great majority of database server-specific SQL syntax extensions for dozens of popular database servers.

 

Active Query Builder for Delphi

Standard VCL Subscription includes:

  • Full version of Active Query Builder VCL Edition
  • Does not include the Advanced SQL Text Editor and Expression Editor
  • Does not include the Advanced SQL Filter Builder
  • Optional: Full Source Code
  • One year of free support and upgrades

 

Professional VCL Subscription includes:

  • Full version of Active Query Builder VCL Edition
  • Advanced SQL Text Editor
  • Advanced Expression Editor
  • Advanced SQL Filter Builder
  • Optional: Full Source Code
  • One year of free support and upgrades

Active Query Builder 3 for .NET - WPF and WinForms Edition
Native components for Windows Forms and WPF, for Visual Studio 2005-2017

Active Query Builder 3 for .NET - ASP.NET Edition
Native ASP.NET component for WebForms, MVC and ASP.NET Core 2.0 environments, for Visual Studio 2005-2017

Active Query Builder for Delphi - VCL Edition
Delphi and C++ Builder component suite for VCL, TNT or DevExpress visual libraries

Active Query Builder for Java
Swing-based Java bean component for all modern Java development environments

Active Query Builder for ActiveX
ASP.NET-compatible ActiveX control for wide range of development environments

 

 

產品目錄

商務工具
  • 專案管理
  • 文檔管理
  • 自動排程
  • 流程管理
  • 條碼製作
  • 列印管理
應用軟體
  • 行事管理
  • 桌面管理
  • 翻譯軟體
  • 傳真伺服器
  • 英語學習
  • 其他應用
  • 光碟工具
開發及程式工具
  • 資料庫開發管理
  • Java & XML
  • 程式碼編輯
  • 程式碼檢查
  • 虛擬裝置
  • 終端機與伺服器
  • 軟體封裝
  • 開發追蹤檢測
  • ASP 工具
  • PHP 工具
  • C++ 工具
  • 日誌分析
  • 電路板設計
  • 開發整合工具
  • 驅動程式開發
  • OPC 工具
  • 圖表開發程式
系統工具
  • 作業系統
  • 磁碟工具
  • 系統優化
  • 效能測試
  • 裝置分析
  • 壓縮工具
傳輸.遠控.郵件
  • FTP伺服器/傳輸
  • 網路通訊
  • 檔案傳輸
  • 遠端控制
  • 網域管理
  • 郵件軟體
資訊安全工具
  • 還原備份
  • 網路監控
  • 系統安全
  • 電腦防毒
  • 資料保護
  • 網路安全
  • 網路分析
  • USB 監控
文書處理
  • 文書管理
  • 文書編輯
  • 文書轉檔
  • 方程式編輯
  • 說明文製作
  • 論文編輯
PDF 應用
  • PDF 編輯
  • PDF 轉檔
  • PDF 加解密
  • Acrobat 插件
網頁相關
  • 網頁設計
  • 網頁瀏覽
  • 網頁安全
  • 網頁分析
  • 網頁打包及管理
圖表編輯
  • 圖表開發程式
  • 圖表製作
  • 圖像編輯
  • 3D 繪圖
  • 圖檔轉換
  • 影像擷取
  • 流程圖製作
簡報排版
  • 字型設計
  • 排版設計
  • 地圖繪製
  • 簡報及電子書
影音軟體
  • 樂曲製作
  • 視頻編碼
  • 影像錄製
  • Flash 製作
  • 動畫製作
  • 影像圖庫
  • 影音分析
  • 影音播放
  • 影音編輯
  • 錄音軟體
  • 字幕軟體
統計分析軟體
  • 統計分析
  • 結構分析
  • 時間序列分析
  • 計量分析
  • 統計流程控制
  • 社會網絡分析
數值分析軟體
  • 決策分析
  • 數值運算
  • 人工智慧
  • 質性分析
  • 生命週期評估
學術研究軟體
  • 化學軟體
  • IRT 應用
  • 生物軟體
  • 水利軟體
  • 視覺思考
  • 數學軟體
  • 互動教學
  • 醫學軟體
  • 物理分析
  • 認知心理
友環股份有限公司   版權所有 2007-2021 Linksoft Inc. All Rights Reserved.

地址: 23504新北市中和區中山路二段351號6樓之10
 
電話: +886-2-2221-2155
 
傳真: +886-2-2221-9008

[email protected]  
http://www.linksoft.com.tw  
關於友環  
聯絡我們   Facebook關注  

會員登入

忘記密碼

會員註冊

Linksoft友環專業軟體代理網站服務,不論會員或非會員均可享受產品詢價和訂購服務。
欲加入會員,可以點選「註冊」成為會員。

加入會員的好處:

1. 您可以隨時登入會員,查詢產品詢價記錄,更新您的會員資料。
2. 系統將自動帶出您的會員資料,免去資料重複繕打的麻煩。
3. 只需填寫基本的聯絡資料,不會要求您留下身份證字號等個人機密性資料。
4. 掌握最新的產品資訊及最新好康,享受完整的客戶服務,註冊的聯繫Email可立即收到通知,再也不用怕漏失重要訊息。

忘記密碼