O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing data from databases

Although tabular models support the import of data from a variety of sources, a relational database is still considered to be one of the primary methods of obtaining data. Unlike other sources (such as text files), where the structure may change from time to time, the data from a database is preferred because it conforms to a schema which is expected to remain constant. Furthermore, most operational systems store their data in a relational database format, and therefore, the database becomes a suitable source of data.

Tabular models may extract relational data through a generic connection on the machine, for example, Open DataBase Connectivity (ODBC), which is a standard method of data access, or by a connection based ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required