XL-DBQuery - Add-In - V1.5.3

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

주의 : 이 제품정보에는 한글안내가 포함되어 있지 않습니다.
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 V1.5.3 - Standard

XL-DBQuery V1.5.3 - Professional

XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Standard

XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Professional

가격에는 ComponentSource의 기술지원 요금이 포함되어 있습니다. 또한 다운로드 판매를 하고 있는 상품의 대부분은 온라인 백업요금이 포함되어 있어서 구입날로부터 30일 이내에 새로운 버전이 발매된 경우 무료로 업그레이드해 드리고 있습니다.  모든 주문에 대해서 당사표준 계약조건 및 반품조건 의 내용이 적용됩니다. 다음의 경우,고객 서비스로연락하시기 바랍니다. (상기의 리스트에 게재되지 않은 대량의 라이센스나 구 버전 등의 라이센스 옵션이 필요한 경우)

일반 적인 소비자 가격은 상기에 표시되어 있습니다. 고객님의 할인가격은 표시 하시려면 로그인 해주시기 바랍니다.

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

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.