Question : This error shows up when I try to connect to database string host:port/servicename. Answer : To connect using […]
Tag: pentaho
PostgreSQL batch inserts fail silent randomly
Question : I have been using Kettle to import data from a SQL Server to PostgreSQL on AWS RDS and […]
Extract data from Oracle DBF files
Question : I’m completely new to Oracle and I was provided with what appears to be an Oracle database backup […]
Pentaho Data Integration – Kettle- Update Identity Column in Microsoft SQL Server
Question : For migration purposes I need to migrate existing ID’s from my old database to my new table in […]
Pentaho Kettle – Unable to connect to virtual Oracle Database
Question : I’m attempting to connect to a virtualized Oracle database but I am receiving the following error: Error connecting […]
How can I control how Pentaho DI formats integers coming from a text file?
Question : I have a simple pipe-delimited text file with integers recorded as a sequence of numbers: 012345|00678 |various|text|fields There […]
How do I get Pentaho Reporting/Kettle to produce PDF reports by business entity?
Question : We use Kettle/PDI to handle usage records from legacy systems and feed them to an analysis database/DWH and […]
How SQL Server determines the data transfer rate
Question : We are having some issues with the data transfer rate when extracting data from SQL Server. Our scenario […]