kettle | Kettle Online Business Intelligence Platform -- Pentaho | Data Migration library

by aoju Java Version: Current License: Apache-2.0

X-Ray Key Features Code Snippets Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | kettle Summary

kettle is a Java library typically used in Migration, Data Migration applications. kettle has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has high support. You can download it from GitHub.

Kettle Online Business Intelligence Platform -- Pentaho Data Integration ( ETL ) a.k.a Kettle

Support

Quality

Security

License

Reuse

Support

kettle has a highly active ecosystem.

It has 14 star(s) with 78 fork(s). There are 2 watchers for this library.

It had no major release in the last 6 months.

There are 1 open issues and 0 have been closed. On average issues are closed in 852 days. There are no pull requests.

It has a positive sentiment in the developer community.

The latest version of kettle is current.

Quality

kettle has 0 bugs and 0 code smells.

Security

kettle has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

kettle code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

kettle is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

kettle releases are not available. You will need to build from source code and install.

Build file is available. You can build the component from source.

It has 18147 lines of code, 1141 functions and 215 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed kettle and discovered the below as its top functions. This is intended to give you an instant insight into kettle implemented functionality, and help decide if they suit your requirements.

Execute job
Monitor status
Send log messages
In email
Send POST request
Convenience method to connect to a URL
Get http request params
Gets the weekday date
Get the number of days between two dates
On access denied
Checks if x is prime
Encrypt a string
Execute KettleResult
Parse email
Get quarter by start date
Download file
Gets the year date
Get url
Generate month date
Encodes the given string
Generate day date
Gets the minute date
Get all classes in given package
To big range
Get the week list
Execute a Quartz queue

Get all kandi verified functions for this library.

kettle Key Features

No Key Features are available at this moment for kettle.

kettle Examples and Code Snippets

No Code Snippets are available at this moment for kettle.

Community Discussions

Trending Discussions on kettle

curl doesn't work from Pentaho Data Integration

Removing html tags from multiple strings array in Javascript/React Native

Meaning of java error "SNO: '+=' reconversion failed"?

Pentaho - How to set job transformation based on Kettle Property File

PowerShell: populate column A null rows with data from previous column A row data, if Column B value is "X"

Convert an org.bson.Document to an org.bson.BasicBSONObject in Java?

Pentaho PDI 9 (Kettle): Kitchen can't continue because the job couldn't be loaded

How to combine and print values of nested object structure?

How to merge lists of different sizes into a dictionary from API?

Basic level linking leaflet to a database - recreating CoffeeShop example

QUESTION

curl doesn't work from Pentaho Data Integration

Asked 2022-Jan-24 at 06:34

I would like to execute the following curl from a transformation using the Execute a process step:

...

ANSWER

Answered 2022-Jan-24 at 06:34

Everything was decided like this:

Source https://stackoverflow.com/questions/70829745

QUESTION

Removing html tags from multiple strings array in Javascript/React Native

Asked 2021-Dec-21 at 07:19

I am receiving some bad data for certain product items and in my react native app its creating a bug where its outputting the bold html tags unintentionally - it isn't doing this in the website as the browser will be converting the bold tags into readable bold text in the web.

I am wondering what the best way would be to check if the array contains the bold tag and filter/remove this out of the state. Here is an example of the data I am getting back and how its currently rendering:

...

ANSWER

Answered 2021-Dec-20 at 11:47

You can use array map()+ string replace() for a quick and dirty fix.

something like this (or better use a regex replace):

Source https://stackoverflow.com/questions/70421185

QUESTION

Meaning of java error "SNO: '+=' reconversion failed"?

Asked 2021-Dec-14 at 16:01

I encountered a mysterious error in Pentaho Data Integration (PDI, a.k.a. Kettle) log displayed via Jenkins:

org.codehaus.janino.CompileException: SNO: "+=" reconversion failed

The only code that contains "+=" is like this...

...

ANSWER

Answered 2021-Dec-14 at 16:01

As strange as it may sound for java, the solution was to simply replace...

Source https://stackoverflow.com/questions/70254632

QUESTION

Pentaho - How to set job transformation based on Kettle Property File

Asked 2021-Nov-23 at 22:47

In my kettle file, I have this variable:

...

ANSWER

Answered 2021-Nov-23 at 22:47

I figured it out.

When you set the my_variable value in the Kettle Properties file, CLOSE OUT of Pentaho (not the file, but the entire software) and reopen it.

Do this anytime you make changes to the Kettle Properties file if you want it to be recognized.

Now, using the exact same set up as my question, it works fine. All I needed to do was close Pentaho completely and restart the software.

Source https://stackoverflow.com/questions/70088670

QUESTION

PowerShell: populate column A null rows with data from previous column A row data, if Column B value is "X"

Asked 2021-Oct-19 at 15:30

I have an oddly formatted csv file that I need to adjust and I could use some help using powershell. I usually have a pretty good idea where to start, but I am at a bit of a loss with this one on how to iterate data from column A from the previous row to the next row based on Column B having "sales order" and only doing it if the Column A field is Null and then using the next row that is populated to continue down the line.

Here is what the csv looks like as a picture:

Here is the actual data:

...

ANSWER

Answered 2021-Oct-19 at 15:30

$Data = ConvertFrom-Csv @'
,Type,Date,Due Date,Num
Inventory,,,,
2.25 Gal Cast Iron KettlewLid (2.25 Gallon Cast Iron Kettle with Lid),,,,
,Sales Order,7/23/2021,7/23/2021,12834
Total 2.25 Gal Cast Iron KettlewLid (2.25 Gallon Cast Iron Kettle with Lid),,,,
Antika Chestnut Brown (Antika Chestnut Brown (87 sqft/pallet - 9.67 sqft/layer)),,,,
,Sales Order,9/23/2021,9/23/2021,13304
Total Antika Chestnut Brown (Antika Chestnut Brown (87 sqft/pallet - 9.67 sqft/layer)),,,,
Antika Onyx Black (Antika Onyx Black (87 sqft/pallet - 9.67 sqft/layer)),,,,
,Sales Order,7/23/2021,7/23/2021,12841
Total Antika Onyx Black (Antika Onyx Black (87 sqft/pallet - 9.67 sqft/layer)),,,,
Antika Sandlewood (Antika Sandlewood (87 sqft/pallet - 9.67 sqft/layer)),,,,
,Sales Order,4/1/2021,4/1/2021,11807
Total Antika Sandlewood (Antika Sandlewood (87 sqft/pallet - 9.67 sqft/layer)),,,,
Antika Shale Grey (Antika Shale Grey (87 sqft/pallet - 9.67 sqft/layer)),,,,
,Sales Order,6/9/2021,6/9/2021,12457
Total Antika Shale Grey (Antika Shale Grey (87 sqft/pallet - 9.67 sqft/layer)),,,,
Architect Cap Champlain Grey (Architectural Cap Champlain Grey (66 linft/pallet -...,,,,
,Sales Order,6/7/2021,6/7/2021,12425
,Sales Order,8/3/2021,8/3/2021,12939
,Sales Order,9/14/2021,9/14/2021,13218
Total Architect Cap Champlain Grey (Architectural Cap Champlain Grey (66 linft/pallet -...,,,,
Architect Cap Chestnut Brown (Architectural Cap Chestnut Brown (66 linft/pallet -...,,,,
,Sales Order,6/8/2021,6/8/2021,12454
,Sales Order,8/24/2021,8/24/2021,13102
,Sales Order,9/14/2021,9/14/2021,13220
,Sales Order,10/8/2021,10/8/2021,13415
'@

Source https://stackoverflow.com/questions/69618669

QUESTION

Convert an org.bson.Document to an org.bson.BasicBSONObject in Java?

Asked 2021-Oct-05 at 14:52

I have a String in Pentaho Data Integration (PDI) a.k.a. Kettle, in a transformation's UDJC step. So using Java, I need to take that String which contains JSON from MongoDB, and put it into a BasicBSONObject. (I can use import statements but I can't install things as part of a solution.)

I got the String into an org.bson.Document so it seems like the hard part's over, but I still can't figure out how to convert one type of bson to another here, resulting in an object of type org.bson.BasicBSONObject

This errors out on the last line:

...

ANSWER

Answered 2021-Oct-05 at 12:50

There is a BasicDBObject#parse method in MongoDB Java Driver library, which is most probably present on the classpath of your application. This method, according to the documentation, parses a string in MongoDB Extended JSON format to a BasicDBObject.

You can use it directly and skip the Document parsing step.

Source https://stackoverflow.com/questions/69446562

QUESTION

Pentaho PDI 9 (Kettle): Kitchen can't continue because the job couldn't be loaded

Asked 2021-Sep-29 at 13:56

I'm not using any repository, I'm trying to run a local job but it doesn't run and even setting log level to debug it doesn't really writes anything useful. I'm calling Kitchen like this (Ubuntu):

sh kitchen.sh -job:"/home/myuser/jobs/job.kjb"

Also tried

sh kitchen.sh -job:"job.kjb" -dir:"/home/myuser/jobs/"

And also tried using "=" instead of ":".

I've seen some people had problems because of the repositories file, but as I said I'm not using any. "repositories.xml" didn't exist tho, so I created it empty on "/home/myuser/.kettle" and "/home/myuser/pdi/data-integration/.kettle" and asked the script to look for some fake repository and it indeed looks for any repos in both files, which it doesn't do if I don't ask it for use any repo.

...

ANSWER

Answered 2021-Sep-29 at 13:56

I found that "dir" only works for pointing at local repository files, not a local directory containing job files. There's another parameter to set the job file route: "file".

sh kitchen.sh -file="/home/myuser/jobs/job.kjb"

Source https://stackoverflow.com/questions/69377573

QUESTION

How to combine and print values of nested object structure?

Asked 2021-Sep-25 at 13:38

I have an array of hashes and each hash needs to be printed out on the same line.

...

ANSWER

Answered 2021-Sep-25 at 13:38

You can iterate the hashes in init_cards_j via each and for each hash call each_value to traverse its values. Then, instead of printing every card right away, you can generate an intermediate array via map and join the result using your separator string:

Source https://stackoverflow.com/questions/69312912

QUESTION

How to merge lists of different sizes into a dictionary from API?

Asked 2021-Sep-21 at 20:00

I have 2 lists from an API, and I want to have one be the keys and the other be the values for a dictionary. The Keys and Values are not even, most keys have multiple values assigned to them; but every time I try to assign the values to the specific keys that the API gave me, I cannot figure out how to align the keys and values together and add it to the dictionary.

...

ANSWER

Answered 2021-Sep-21 at 20:00

You can use defaultdict:

Source https://stackoverflow.com/questions/69274739

QUESTION

Basic level linking leaflet to a database - recreating CoffeeShop example

Asked 2021-Sep-07 at 08:42

I am trying to work through the example from Chapter 5 of the Leaflet.js succinctly book - but cannot get any of the coffee shops to show on my map.

Some of the commands give me errors so I've looked for workarounds, and I suspect the problem could be as simple as files not being in the correct place. Is there an idiot's guide to using databases with leaflet I could follow? Or can someone see the error I am making?

My set up:

using XAMPP on a Mac - the MySQL Database and Apache Web Server are running
I created the leafletDB database using the terminal /Applications/xampp/xamppfiles/bin/mysql -u root -p create database leafletDB
I filled the database by copy paste into the terminal the contents of the CoffeeShops.sql file (I could not get the from CSV command mysql –uroot –pleaflet < "C:\CoffeeShops.sql"; to work, even changing the path to CoffeeShops.sql)
Checking the database using USE leafletDB; SHOW TABLES; and SELECT COUNT(*) FROM coffeeshops; all gave the expected results.
The leaflet database is located in /Applications/XAMPP/xamppfiles/var/mysql/
I copied the coffee.php file to the /Applications/XAMPP/xamppfiles/htdocs/CoffeeExample folder, which is the same file as the listing43.html file (the file that creates the map)
The only change I made to the listing43.html file was the path to the mugIcon (put in the same folder). I also tried simply removing the icon command - it made no difference.

The map displays, any markers coded directly into the html file display - but nothing from the database.

What have I got wrong?

As requested here is a copy of all the code - sorry for how long this is

listing43.html

...

ANSWER

Answered 2021-Sep-07 at 08:42

Right.

I tried running this in an apache docker-container, and a mysql db in another docker-container. I got a couple of suggestions as to the possible errors. Although I believe suggestion 2-4 are the most likely to help you.

The link you use for importing JQuery seems to be dated. Instead of:

Source https://stackoverflow.com/questions/68969541

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install kettle

You can download it from GitHub.
You can use kettle like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the kettle component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: