January 13, 2014
By Tim Kerian and Tom Passe
Information access is critically important for users of Infor back office business applications. Although Infor offers a comprehensive suite of embedded reporting and query interfaces within our applications, we also understand that some end users are accustomed to using their own ‘preferred’ third party tools to access non-Infor back office applications that do not provide adequate reporting tools. Infor strives to satisfy our user community by enabling our applications to be accessed by these popular third party tools. Users are given a choice on how they wish to access Infor application data.
Two user preferred tools available for Landmark based application access include:
• Infor Spreadsheet Designer for Microsoft Excel (Spreadsheet Designer)
• Infor OLEDB Object Services Query Builder (Query Builder)
The Infor Spreadsheet Designer for Microsoft Excel (Spreadsheet Designer) provides a reporting and analysis interface between Infor Landmark based applications and Microsoft Excel. The Infor OLEDB Object Services Query Builder (Query Builder) provides a reporting and analysis query builder interface between Infor Landmark based applications and popular reporting tools such as Crystal Reports and Microsoft Excel.
Using the Spreadsheet Designer and Query Builder, your end users are empowered to access data within your Infor applications including all Infor Talent Management applications, Infor Lawson Supply Chain Management Landmark extension applications, and Infor Lawson Enterprise Financial Management Landmark extension applications.
Both the Query and Spreadsheet Designer use application role-based security authorization policies and rules as defined by your applications. Secure access is controlled and administered by the application to restrict access.
Key benefits of Spreadsheet Designer and Query Builder include:
• End users leverage existing third party tool knowledge to access applications using secure CRUD (Create Read Update Delete) queries and reports
• End users can easily interrogate their Infor application data and then quickly create their own ad hoc reports for flexible and dynamic information access
• Increase efficiency and timeliness of information access across your enterprise by enabling users to combine Infor data with other non-Infor data in their preferred tool, for example Microsoft Excel
• Provides sharable and reusable ad hoc queries and reports within Microsoft Excel and Crystal Reports and it is database independent
• Security ‘For Your Eye’s Only’: access is controlled by each application’s role based security authorization model. End users can only access data and information they are authorized to see. Keep in mind that secure control is lost once a report is ‘disconnected’ from the Infor back office application.
Here is a demonstration video illustrating how quick and easy it is to connect, interrogate and create a query and report. The example shows Infor Query Builder accessing Infor’s Lawson Enterprise Financial Management application, Cash and Treasury Management – a single, centralized application to manage cash, forecasting, and other treasury-related functions that improve your ability to understand your cash positions and take effective action.
Senior Infor Business Analyst, Tim Kerian, has provided a step by step demonstration of building a Query Builder connection, creating a query, and executing it within Crystal Reports. If you have any adhoc reporting examples that you have created (or need,) we’d love to hear about them in the blog comments.