Profile

Team, We are using pentaho community edition release 9.1.0.0-324. We would like to use UI  "Copy Tables.." wizard via ktr or command line.  Is there any way we can use that programmatically? Is there any other ktr that can create source table in to target db? Thanks, Priyesh Patel JPMorgan Chase.

Petr, Right.. I was looking in job. I see Postgres bulk loader option in transform. I will try that and see. Thanks Priyesh JPMChase ------------------------------ Priyesh Patel Systems Engineer JPMorgan Chase ------------------------------

Team, I am migrating data to MySQL and frequently getting connection reset errors. It's around 16GB table. I tried to enable connection pooling but job hangs.  Can you shad some light on it.  Error:  Thanks, Priyesh K Patel JPMorganChase ------------------------------ Priyesh Patel Systems Engineer ...

Petr, Appreciated your quick reply. Below is my Pentaho version.    Thanks, Priyesh ------------------------------ Priyesh Patel Systems Engineer JPMorgan Chase ------------------------------

Petr,  Thanks for this options. We are migrating data for all tables so we can't construct insert statement and execute it separately.   Also I do not see PostgreSQL bulk loader in Pentaho community edition.  We are thinking create tables columns on Postgres target using boolean data type.  thanks Priyesh ...

Hi Petr, Appreciated your reply back. unfortunately on  target, app require similar data. Is there any alternative way to map bit data in to Pentaho? like using meta data injection or use java code before it insert data in to target?  Thanks, Priyesh Patel JPMChase ------------------------------ Priyesh ...

Hello,  I designed transform to migrate data from MariaDB to AWS Arora Postgres using Pentaho community edition. While inserting data to target. Bit data type is taking as Boolean and insert fails on target tables.  I am using below jar drivers. Source Maridb: mysql-connector-java-8.0.29.jar Target ...