| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Prerequisites
You need an installed version of the Pentaho Data Integration Server (DI-Server) or Carte with Version 5.0 GA (Enterprise Edition) or later versions.
...
| Code Block |
|---|
<slave_config>
[...]
<repository>
<name>Repository Name (idshown within Spoon as the ID)</name>
<username>username</username>
<password>password</password>
</repository>
</slave_config>
|
| Panel |
|---|
Note: The Repository Name is shown in your Repository Configuration screen within Spoon as the ID. Within the repositories.xml file the Repository Name is stored in the <name> element. The given user needs to have access rights to the DI repository. The password can given encrypted (using the Encr tool). If you are doing this the first time after the default installation: For the DI-Server repository you can use the standard admin account to test with password "password". |
...
| Panel |
|---|
Note: When running the DI-Server as a Windows server, please remember that the KETTLE_HOME folder with the repository.xml file is depending on the Log on user-name of the Windows Service named Data Integration is running with (you can verify the Log on user account within the Windows services). This is by default the local system account and may need to be changed to a different log on user acount according to your needs. You can find further information about Changing the PDI Home Directory Location (.kettle folder) within the InfoCenter. |
- Make sure to restart the DI Server (or the Data Integration Windows service)
- You can check the successfully connection to the DI repository by opening the DI-Server page, after login e.g. http://localhost:9080/pentaho-di/kettle/status
- Please check the information in the Configuration details / Repository name: There should be the correct name and no error.
- List the services, e.g. by http://localhost:9080/pentaho-di/kettle/listServices
once you defined a service within the DI Repository it is listed here
...
| Code Block |
|---|
<slave_config>
[...]
<repository>
<name>Repository Name (idshown within Spoon as the ID))</name>
<username>username</username>
<password>password</password>
</repository>
</slave_config>
|
| Panel |
|---|
Note: The Repository Name is shown in your Repository Configuration screen within Spoon as the ID. Within the repositories.xml file the Repository Name is stored in the <name> element. The given user needs to have access rights to the DI repository. The password can given encrypted (using the Encr tool). If you are doing this the first time after the default installation: For the DI-Server repository you can use the standard admin account to test with password "password". Remark: This is not the login user name for the Carte server (by default cluster/cluster as defined in the data-integration/pwd/kettle.pwd file |
...
- The JDBC driver uses the following class: org.pentaho.di.core.jdbc.ThinDriver (Note: This is the Pentaho 5.4.x and earlier driver class.)
- The URL is in the following format: jdbc:pdi://hostname:port/kettle?option=value&option=value
...