This example illustrates how a connection is established from Spoon in Pentaho Data Integration to an Invantive UniversalSQL database on Invantive Cloud. Invantive UniversalSQL Server has been tested with Spoon version 11.0.0. ## Prerequisites Ensure the following prerequisites are met: - A database has been registered on Invantive Cloud. - The IP address from which Pentaho Data Integration connects is whitelisted. ## Install Certificate When not configured, please remember to make the certificate available to Java using logic like: ```bat rem rem As user with write privilegse to cacerts. rem keytool -importcert -alias mycert -file certificate.pem -cacerts -storepass changeit ``` The PEM-file is currently only available by request at Invantive Forums. In a future release, the PEM may be made available from within a website or Invantive Cloud. ## Login Register a database connection in Spoon using the connection type "MS SQL Server (Native)" with the following settings: - Host Name: host name from Invantive Cloud. - Database Name: alias of the data container. - Instance Name: leave empty. - Port Number: always 1433. - Username: the Invantive Cloud user name. - Password: the Invantive Cloud user password. Verify against the following image: ![[Pasted image 20260511173904.png]] Then verify using the "Test" button that the database connection is being established: ![[Pasted image 20260511174140.png]] ## Job A Pentaho Data Integration job can be defined using a table input and written to Excel: ![[Pasted image 20260511173820.png]] The job can be executed: ![[Pasted image 20260511173748.png]] ## Limitations As of release 26.0, there are no known limitations when used with Pentaho Data Integration.