PDI has the ability to connect to both commercial RDBMS such as Oracle or MS SQL Server, and free RDBMS such as MySQL or PostgreSQL. In order to interact with a particular database, you have to define a connection to it. A PDI database connection describes all the parameters needed to connect PDI to a database. To create a connection, you must give the connection a name and at least fill in the general settings as follows:
|
Setting |
Description |
|
Connection Type |
Type of database system: HSQLDB, Oracle, MySQL, Firebird, and so on. |
|
Method of access |
Native (JDBC), ODBC, JNDI, or OCI. The available options depend on the type of database. |
|
Host name |
Name or IP address for ... |
