XL-DBQuery - Add-In - V1.5.3 - 개요

개요 | 가격 및 라이센스 | 평가판과 다운로드 | 호환성 | 개발처 정보 | 리뷰 | 지원 포럼 | 요약

요약

XL-DBQuery by SBS Development

Analyse your corporate data with an easy to use analysis and reporting tool for Excel. XL-DBQuery from SBS Development is a data analysis and reporting tool for Excel that enhances Excel’s existing analysis and reporting capabilities and is a viable alternative to Excels own ‘MS Query’. It is based on the popular Query Builder ‘Automated-SQL-Builder’. With little effort, users can easily connect, query and analyse corporate data and use Excel’s familiar functionality to create reports based on the data returned by XL-DBQuery.

XL-DBQuery is an Add-in for Excel that sits neatly inside Excel’s existing tool set. XL-DBQuery has been designed to expand on Excel’s existing data analysis and reporting capabilities by providing users with ‘self-service’ access to corporate data. With little effort, users can easily connect, query and analyse corporate data and use Excel’s familiar functionality to create reports based on the data returned by XL-DBQuery.

XL-DBQuery is intuitive and simple to use. Users will no longer need the assistance of specialists or I.T. Departments to service their requests for information

XL-DBQuery has been designed with both novice and advanced users in mind and even the most complex requests for information can be quickly and efficiently serviced.

XL-DBQuery uses assumptions influenced by the query criteria already entered by the user. This also extends to the selection of AND/OR conditions, an area that is often confusing for many novice and occasionally even experienced users. This approach means that assembled queries nearly always reflect the user’s requirements and often means that no further modifications are required to the assembled query.

Here are just a few more examples of the benefits that XL-DBQuery can bring to your business:

A simple and intuitive user interface

A viable alternative to Excels ‘MS Query’

Compatible with Excel 2000 and above, Including Excel 2007

Utilises users existing Excel skills and extends Excels built-in analysis and reporting capabilities by providing a bridge to your corporate data

‘Self-service’ style analysis and reporting for novice and advanced users alike

Query assumptions help users build the queries they want quickly and efficiently without having to learn new skills

Adheres to existing Database security measures

Export data to Excel as standard row column reports or multi-dimensional pivot table reports for dynamic analysis of corporate data

Refresh exported results directly from Excel

Share corporate data with colleagues and co-workers

Join and merge data from different data sources

Query and analyse virtually any corporate data source within your organisation

Digitally signed (VeriSign) for extra peace of mind

Standard Edition - includes all features with the following exceptions:

Unable to create a connection to external datasources, i.e. SQL Server, Oracle, etc

Unable to create joins between tables/views

Unable to manually edit query SQL using the SQL Scratch Pad feature

Professional Edition - Unlimited functionality.

What's new in XL-DBQuery V1.5x?

New feature added - The 'Query Tree View'. Allows users to view assembled queries in a hierarchical manner. Improves overall understanding of query syntax

New feature added - Export and convert query results as a CSV text file. Gives further opportunities to import results into other software or merge data from different sources

New feature added - Users are now able to sort available fields in database order (default) or ascending order

New feature added - Both table and field lists will automatically include a horizontal scroll bar if any table or field names exceed the width of the table or field list

Enhancement to existing feature - Users can now select up to 500 values from an Excel worksheet. Previous limit was 25 values

Many additional minor enhancements designed to improve overall performance and user experience

What's new in XL-DBQuery V1.1?

New feature added to XL-DBQuery that allows users to create parameter queries that can be dynamically updated from Excel. (Requires ODBC connection)

New Save/Save As Data Source library file feature added

New feature added that allows users to return query results to Excel without needing to run and preview the query first

Query builder load speed has been improved when connecting to Data Sources containing large numbers of tables and fields

Improved data source connection wizard to easily connect & query Microsoft Excel and Access

Fully compatible with Microsoft Office 2007

Fully compatible with Windows Vista O/S

PartNumbers: PC-517416-132888 517416-132888 PC-517416-132889 517416-132889 PC-517416-132890 517416-132890 PC-517416-132891 517416-132891 PC-517416-132892 517416-132892 PC-517416-132893 517416-132893 PC-517416-132898 517416-132898 PC-517416-132894 517416-132894 PC-517416-132895 517416-132895 PC-517416-132896 517416-132896 PC-517416-132897 517416-132897 PC-517416-132899 517416-132899 PC-517416-132901 517416-132901 PC-517416-132902 517416-132902 PC-517416-132903 517416-132903 PC-517416-132904 517416-132904 PC-517416-132900 517416-132900 PC-517416-132905 517416-132905 PC-517416-132906 517416-132906 PC-517416-132907 517416-132907 PC-517416-132908 517416-132908

PurchaseOptions: XL-DBQuery V1.5.3 - Standard 1 User License , XL-DBQuery V1.5.3 - Standard 5 User License , XL-DBQuery V1.5.3 - Standard 10 User License , XL-DBQuery V1.5.3 - Standard 25 User License , XL-DBQuery V1.5.3 - Standard 50 User License , XL-DBQuery V1.5.3 - Professional 1 User License , XL-DBQuery V1.5.3 - Professional 1 User License - Upgrade from Standard , XL-DBQuery V1.5.3 - Professional 5 User License , XL-DBQuery V1.5.3 - Professional 10 User License , XL-DBQuery V1.5.3 - Professional 25 User License , XL-DBQuery V1.5.3 - Professional 50 User License , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Standard 1 User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Standard 5 User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Standard 10 Standard User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Standard 25 Standard User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Standard 50 Standard User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Professional 1 User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Professional 5 Professional User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Professional 10 Professional User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Professional 25 Professional User License Educational or Non-profit Organization , XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Professional 50 Professional User License Educational or Non-profit Organization

Resources: Read the XL-DBQuery License Agreement, Download the XL-DBQuery V1.5.3 evaluation on to your computer - Limited Functionality

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000, Windows 98, Windows NT 4.0, Windows NT 3.51

Architecture of Product: 32Bit

Product Type: Add-In

Compatible Containers: Microsoft Office 2007, Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000

Keywords: Mining analyze analyse analysis　データ分析 Database DB Reporting Report reports SQL query language Database DB Connectivity Author Excel Add In SQL Query MS Office