Stack Overflow
Stack Overflow

Questions tagged [pentaho-data-integration]

Tag to be used for Pentaho Data Integration (all versions). Pentaho Data Integration prepares and blends data to create a complete picture of your business that drives actionable insights.

Pentaho Data Integration prepares and blends data to create a complete picture of your business that drives actionable insights.

It provides intuitive drag-and-drop data integration coupled with data agnostic connectivity spanning from flat files and RDBMS to Hadoop and beyond.

Features:

  • Graphical extract-transform-load (ETL) designer to simplify the creation of data pipelines
  • Rich library of pre-built components to access, prepare, and blend data from relational sources, big data stores, enterprise applications, and more
  • Powerful orchestration capabilities to coordinate and combine transformations, including notifications and alerts
  • Agile views for modeling and visualizing data on the fly during the data preparation process
  • Integrated enterprise scheduler for coordinating workflows and debugger for testing and tuning job execution
825 questions
0
votes
1 answer

Share Database connections across transformations in pentaho kettle

I want to share database connections that I use for a transformation across other transformations. Is it possible in Pentaho Kettle? If yes then how? If no, is there any other workaround for the same except for manually defining all the DB…
Megh Vidani
  • 635
  • 1
  • 7
  • 22
-1
votes
0 answers

Can anyone suggest how can i perform XSLT Transformation in Pentaho.Since i am new to this ETL Tool?There isn't much blogs on this in penttaho

Can anyone suggest how can i perform XSLT Transformation in Pentaho.Since i am new to this ETL Tool?There isn't much blogs on this in penttaho My requirement is to compare my input fields and transform based on the stylsheet what ihave defined in…
Srinivas M G
  • 1
-1
votes
2 answers

save multiple csv to multiple table in table output

I have multiple csv file for example 1.csv,2.csv,3.csv then I want to create each csv file new tables in my postgres database. currently im using "get file names" to read my folder that contains multiple csv files, then im using "CSV file input" to…
SharkJr
  • 1
  • 2
-1
votes
2 answers

Could not connect pentaho with oracle

enter image description here this is my first time to use pentaho woth oracle. I tried to add ojdbc8.jar file into /lib but nothing changed. Can someone help on how to connect them I tried to add ojdbc8.jar file into /lib but nothing changed. I…
Muhammad Muizzuddin Muskamal
  • 1
-1
votes
1 answer

Mismatch on the day of week and week name in Pentaho

I am creating a date dimension table using pentaho and im following the tutorial linked https://www.fabguy.de/howto-create-a-date-dimension-with-pdi-kettle.html but when I preview my data, I found a mismatch between the column day of week and the…
Allen
  • 3
  • 2
-1
votes
1 answer

How to use loop to find related object using Pentaho Data Integration

I want to identify the bad/invalid records so that i can add in a separate SQL Table. For example, we have an account object. And i want to find bad accounts. But i need to apply some filters on contact object. If conditions satisfy based on contact…
Tayyaba Noor
  • 1
  • 1
-1
votes
1 answer

Delete records from MySQL source database table ,after copying to MySQL target database using Pentaho spoon

I would like to do the below operation using Pentaho spoon/PDI. Copy data from the Mysql source database to the Mysql target database. 2)After that I would like to truncate/Delete Data from Source Database Can Someone help with this?
Pydi Raju
  • 103
  • 3
-1
votes
1 answer

Pentaho Text Input multiple languages English and Japanese Characters Loaded into MSSQL data table separate columns

I am trying to load a SQL table with a text file. I am using the Text File Input Step. All but one column may contain Japanese characters(Comment). How can I pass all English text and Japanese text as readable characters? Is there a regex or Java…
CPHILLIPS1234
  • 45
  • 4
-1
votes
1 answer

Correct Json Path to extract the data

i have a json structure like that, where i would like to take from the json path the "id", but when i run the JSON input method in pentaho, putting "$..id" as the path, it returns me two lines about the same person, one containing the first id and…
user15936034
-1
votes
1 answer

pentaho transpose n columns to one column

I want to transpose n columns in inputfields to one…
usef
  • 17
  • 1
  • 4
-1
votes
2 answers

How I can read the file on the everyday basis in pentaho in this format? "tcms_oneed_YYYYMMDD.txt"

I want to read the file from FTP server to pentaho with this particular format. tcms_oneed_YYYYMMDD.txt YYYYMMDD is the sysdate.
Aaron
  • 1
  • 1
-1
votes
1 answer

create a cube using Pentaho BI server 7 and schema workbench for Sampledata database

I'm trying to create a cube in a pentaho workbench, to the Sampledata database (type: Hypersonic), and publish it in pentaho BI server, but when I try to publish, it cannot be published. Please, if you have any ideas? or let me know if you think I…
Siham
  • 89
  • 1
  • 1
  • 4
-1
votes
2 answers

How to get data from excel and pass excel values as parameters in SQL query on pentaho etl jobs

I'm new to the pentaho etl jobs .. I need to get data from excel and pass the excel sheet value to MySQL query as parameter. If it's possible in etl pentaho jobs .. any know please help me
Sridhar Lovevirus
  • 1
  • 2
-1
votes
1 answer

how to configure the Penthao 8.2 bulk insert with snowflake?

how to configure the Penthao 8.2 PDI bulk insert with snowflake? Or is there any plug in available to bulk insert?
Jeyavel
  • 2,974
  • 10
  • 38
  • 48
-1
votes
1 answer

Slowness while reading ms sql data from Pentaho data integration spoon

My pentaho data integration(pdi-ce-7.1.0.0-12) job is taking too much time to read data from MS SQL Server 2008 R2. PDI spoon Application server is installed on Windows server. Pentaho data integration application server and MS SQL Server is on…
Kedar Patwardhan
  • 1
  • 1
1 2 3
…
54
55