Connecting to Data Sources

Objectives

After completing this lesson, you will be able to:

  • Set a data source

Data Source Selection for a Report

The data that you use to create reports in your organization is stored in either a client-server database such as MS SQL Server, or a PC-type database such as Microsoft Access. You access sources through either an ODBC layer or directly through native drivers. ODBC stands for Open Database Connectivity. It is an interface that gives applications the ability to retrieve data in data management systems.

Hint
In your organization the database may be secure, meaning you might be prompted for a user ID and password.

The Database Expert displays with the connection to the data source highlighted.​ ​

Log in to track your progress & complete quizzes