SYMTRAX

JD Edwards - Reports in Excel with StarQuery Suite

StarQuery for JDE is an ad hoc querying tool that automatically adjusts for JDE Database quirks enabling end-users to create meaningful queries directly with Excel or via the web.
StarQuery for JDE offers users an intuitive view of their database by automatically correcting issues related to dates and decimals and augmenting field names with descriptions from the JDE data dictionary. The view can be further tweaked by renaming data fields as needed. A short learning curve and quick ROI is ensured through a tight integration with Microsoft Excel and automation of delivery and publication via email or the web.

Everyday reporting challenges faced by JDE administrators

• Constantly spending time supporting end user requests
• Need to depend on RPG programmers
• Regularly creating customized reports for each different department
• Concern over database security when giving end users querying rights

• Incapable of extracting a wide range of data from JDEdwards ERPs
• Can't customize JDE reports to their specific requirements
• Have to rely on the IT department to create their reports
• Not familiar with JDE table names, descriptions and the data within
• Lack of ad-hoc reporting functionalities for instantly creating excel reports

• Powerful and flexible tool for Microsoft Excel Reporting
• Intuitive interface creates self-sufficient end user reporting
• Affordable Price-Point achieves a fast ROI
• Easy and quick to deploy
• Easy-to-learn, easy to use, secure and eliminates tedious cut & paste and re-keying
• Capitalize on existing infrastructure and JDE outputs without programming

• Automatically converts Julian dates to "normal" format, field descriptions and decimals
• Automated output in a variety formats (Excel, PDF...) via Email and FTP
• End users can further modify field descriptions as needed
• Highly secure, users see only what the DB Administrator allows them to see