Reporting Tools for Evaluation
The following list captures the applications, languages, and other tools used for library reporting by members of the Reporting SIG.
Tool | Info | Tool Type | Data Source/LMS | Data Source Type | Data Export Method | Used with LMS |
|---|---|---|---|---|---|---|
Microsoft Access and Excel | application | Voyager | relational database system | SQL queries | Cornell | |
Tableau | application | flat files, database, data warehouse, cloud | ||||
"R" | programming language | Voyager | relational database system | SQL queries | Cornell | |
IBM Cognos | ||||||
Crystal Reports | relational database system, flat files (Excel, test), XML; data accesible via web services, JDBC etc. | |||||
PERL | scripting language | Voyager | relational database system | Cornell | ||
BIRT | integrated with OLE, open source | Wizards are provided to access a number of data sources (Excel, flat file, Hive, JDBC data sources, MongoDB, scripted data sources, web services, XML etc.). In addition, developers can write JavaScript or Java to get data from Java objects. | BSZ, Lehigh | |||
SSRS (SQLServer Reporting Services) | relational database system | SQL queries | ||||
Kibana | open source | elasticsearch engine indices | ||||
IBM Congos Ex Libris version | ||||||
SQL and PERL | ALEPH | |||||
Microsoft Access and Excel | OLE | UChicago | ||||
OpenRefine | Used mainly for data cleanup. Has been used in connection with KB+/GOKB activities. | application software | German FOLIO Project Team | |||
Aqua Data Studio | A graphical tool to implement SQL queries. Similar to DBeaver. Can be expensive. It is not statistics software, but just a comfortable substitute for executing SQL on the command line. Written in Java. | graphical administration tool | LBS | relational database system | SQL queries | VZG, widely used (Expert: @Uschi Klute Klute). |
Presentation "Metadata Management with KNIME" held on SWIB 2017 – See KNIME Slideshow | GUI-driven data management application, open source version available (extra functionality requires licensing), written in Java | any source - simple text formats (CSV, JSON, XML etc.), databases and data warehouses (Oracle, Microsoft SQL, Apache Hive etc.), other sources (AWS S3, Google Sheets, Azure etc.) | Can create report templates that can be exported to document formats like doc, ppt, xls, pdf and others. | UB Heilbronn | ||
BibControl | available in German, English and Scandinavic Languages | Controlling software by OCLC | LBS | collects data into a data warehouse | uses Data Mining, OLAP | GBV/VZG, hbz |