1 / 14

Advanced SQL Reporting

Advanced SQL Reporting. Welcome. Connect Conference 2013. This is an exciting opportunity for everyone involved. The benefits go beyond just training and education—collaborate with your peers and inspire others around you. educate • collaborate • inspire. Advanced SQL Reporting.

judith
Download Presentation

Advanced SQL Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced SQL Reporting

  2. Welcome Connect Conference 2013 This is an exciting opportunity for everyone involved. The benefits go beyond just training and education—collaborate with your peers and inspire others around you. educate • collaborate • inspire

  3. Advanced SQL Reporting In this session, we will learn: designing reports through C1 reporting tool; reviewing standard compiled SQL tables utilizing MS Visual SQL Studio; and understanding how the data and where the data is located in the standard SQL table views.

  4. Advanced SQL Reporting EBS Import Control Panel • Validate data • Full import vs. delta import • Understand how to schedule imports • Number of months in history • 4.0 GB vs. 10.0 GB (8.26 vs. 10.0) • Exceptions (data import) • SQL status: Running

  5. Advanced SQL Reporting EBS Import Control Panel

  6. Advanced SQL Reporting EBS SQL Panel

  7. Advanced SQL Reporting SQL Metrics • Where to find the name of SQL tables • Understand the columns in a table • What is a view? • Compact databases

  8. Advanced SQL Reporting SQL Metrics

  9. Advanced SQL Reporting C1 Reporting • C1 reporting requires authorization • Understand a simple SQL report • How to drag and drop fields • How to change sorts and groups • What is a simple SQL statement • Select * from (ViewTable) For additional training on SQL statement writing, contact your local college or university.

  10. Advanced SQL Reporting SQL Source Line for C1 Reporting • Provider=SQLOLEDB.1;Password=db_user;Persist Security Info=True;User ID=netclient;Intitial Catalog=Ensite;Data Source= (LOCAL)\eci2 This is the universal source line for C1 to allow any report to run on any ECi DDMS machine.

  11. Advanced SQL Reporting C1 Connection String

  12. Advanced SQL Reporting Microsoft SQL Server Management Studio • Free software available from Microsoft • Understand how to: • Log in and select the correct database • Drill down (Tables and Views) • View columns • Execute query to view data • Export the table to Excel • Create a query

  13. Advanced SQL Reporting

  14. Customer Service & Support Contact Information Training • (800) 959-3367 option 5 • professional.services@ecisolutions.com • Virtual classes offered monthly • One-on-One training via virtual classroom • Onsite training Support • (800) 366-4778 • Monday - Friday • 7AM to 7PM • 24/7 Support Services are available on a billable basis outside of regular business hours, 7 days a week

More Related