Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: pentaho

How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?

By adminPosted on December 1, 2022

Question : This error shows up when I try to connect to database string host:port/servicename. Answer : To connect using […]

PostgreSQL batch inserts fail silent randomly

By adminPosted on July 25, 2022

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

By adminPosted on March 17, 2022

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

By adminPosted on May 28, 2021

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

By adminPosted on February 27, 2021

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?

By adminPosted on February 20, 2021

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?

By adminPosted on December 12, 2020

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

By adminPosted on November 28, 2020

Question : We are having some issues with the data transfer rate when extracting data from SQL Server. Our scenario […]

Recent Posts

  • Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring
  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding