A reporting solution currently owned by SAP. Read-only environment that allows you to build complex report files from a relational database. Strengths are with formatting and presentation.
“Microsoft SQL Server”
The base engine that resides on a server that controls one or many SQL databases. Very popular RDBMS.
Stands for “Open Database Connectivity”. A standard interface for connecting to a relational database system. Windows applications and reporting tools can use this technology to access a RDBMS data across a network.
A type of SQL Statement that returns data from the database. Most often it begins with the SELECT keyword. Queries are read only and typically do not change any data. Data for all reports are built from some sort of a query.
“Relational Database Management System” (RDBMS)
Type of database structure, different than hierarchical. Tables…