The main function of data connection is to store all the required information to access a specific data source. Each data connection will connect to a specific type of data source, and you can use the same data connection to create multiple Data Foundation layers. Data connection is like a bridge between our Universe and physical database. The data connection middleware driver is the translator that will communicate directly with the database. There are two data connection types: the relational connection and the OLAP connection.
We already created a relational data connection in the previous chapter, but we will talk about supported database middleware drivers that we have. Actually, you can find a driver for almost all known databases such as Oracle, MS SQL, and Teradata. You can also create a connection to the SAP database (MaxDB) and SAP HANA.
We might edit/change a driver or test a connection after we create our relational data connection...