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. ## Prerequisites Ensure the following prerequisites are met: - A database has been registered on Invantive Cloud such as ActiveCampaign or Exact Online. - The IP address from which Pentaho Data Integration connects is whitelisted. ## Install Certificate When not configured, please remember to make the certificate used to encrypt database traffic 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 available at https://URL/database.pem. ## 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: ![[20260511-pentaho-spoon-database-connection.png]] Then verify using the "Test" button that the database connection is being established: ![[20260511-pentaho-spoon-connection-test.png]] ## Job A Pentaho Data Integration job can be defined using a table input and written to Excel: ![[20260511-pentaho-spoon-table-input.png]] The job can be executed: ![[20260511-pentaho-spoon-job.png]] ## Limitations As of release 26.0, there are no known limitations when used with Pentaho Data Integration.