Search Options
Skip to main content (Press Enter).
Sign In
Skip auxiliary navigation (Press Enter).
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Communities
General Discussion
My Communities
Explore All Communities
Products
Solutions
Services
Developers
Champions Corner
Customer Stories
Insights
Customer Advocacy Program
Badge Challenges
Resources
Resource Library
Hitachi University
Product Documentation
Product Downloads
Partners Portal
How To
Get Started
Earn Points and Badges
FAQs
Start a Discussion
Profile
My Contributions
List of Contributions
Profile
Vadim Kalyshkin
This individual is no longer active. Application functionality related to this individual is limited.
Contact Details
×
Enter Password
Enter Password
Confirm Password
Vadim Kalyshkin
This individual is no longer active. Application functionality related to this individual is limited.
Profile
Connections
Contacts
Contributions
Badges
List of Contributions
My Content
1 to 14 of 14 total
search criteria =
ALL
RE: issue while creating database connection using Generic database type
Posted By
Vadim Kalyshkin
08-13-2019 09:03
Found In
Community:
Pentaho
\
view thread
Hi Revathi you need to download the Denodo JDBC driver. Here is the more info https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Denodo%20from%20Pentaho?category=Northbound+Connections
Run the Job outside PDI
Posted By
Vadim Kalyshkin
03-20-2019 17:15
Found In
Community:
Pentaho
\
view thread
Hi Guys I need to run the Job called My Job and to define the Parameter Called Name from Command line. Could you pls assist with the building of the required command? I know about Pan, but somehow smth doesnt work Thank you #Pentaho #Kettle #PentahoDataIntegrationPDI
RE: Cleaning the Pentaho BI Mondrian Cache from PDI
Posted By
Vadim Kalyshkin
03-07-2019 08:55
Found In
Community:
Pentaho
\
view thread
Thanks. Does it mean, that you just switched to another BI?
RE: Settings for "Salesforce input" step: Salesforce Webservice URL?
Posted By
Vadim Kalyshkin
03-05-2019 15:16
Found In
Community:
Pentaho
\
view thread
and you have also to use the corect user name (you wil find it in SF) and PASSWORD+SECURITY TOKEN
RE: Settings for "Salesforce input" step: Salesforce Webservice URL?
Posted By
Vadim Kalyshkin
03-05-2019 15:15
Found In
Community:
Pentaho
\
view thread
I also struglled with this, its not about trial i guess. You have to find the pdi-salesforce-plugin folder and check the api version. For me was by default also 41, but the correct one is 37 https://login.salesforce.com/services/Soap/u/37.0 Vadim
Cleaning the Pentaho BI Mondrian Cache from PDI
Posted By
Vadim Kalyshkin
03-05-2019 13:34
Found In
Community:
Pentaho
\
view thread
Hi Guys as my Data Base is changing constantly, to get the right data in Pentaho BI dashboard I have to clear my cache either manually or by calling API Below is the Call Api block with the following URL http://localhost:8082/pentaho/api/system/refresh/mondrianSchemaCache But when I run this transformation, ...
RE: How does Pentaho BI server works?
Posted By
Vadim Kalyshkin
02-26-2019 19:38
Found In
Community:
Pentaho
\
view thread
Hi Ana I have another question related how BI Server works. It seems like the data in my report are not updated automaticaly once the data in DB has changed. If I run the transformation, which change the data in the source DB, in my report I still see the previous data. Do you know how can i change it? ...
Data in Report are updated with Lag
Posted By
Vadim Kalyshkin
02-24-2019 12:32
Found In
Community:
Pentaho
\
view thread
Hi all Ive created the report, which takes the data from Postgres. When I open the report, it shows the correct info. Than if I run the transformation, the data are updated in database, but the report still shows the same values after the refresh. If i make the refresh in approx 5-10 min, the data are ...
RE: SQL Statement using variables in PDI
Posted By
Vadim Kalyshkin
02-22-2019 12:50
Found In
Community:
Pentaho
\
view thread
Thanks for you comments. Actually I knew the answer from the begining, but PDI didnt work correctly with my request. (dont know why, but Ive mentioned this working with kettle a little bit) Thats why I was confused and everyone in this chat as well. After the restart of kettle it provided me with the ...
RE: SQL Statement using variables in PDI
Posted By
Vadim Kalyshkin
02-20-2019 14:16
Found In
Community:
Pentaho
\
view thread
So, everything works. Thanks all
RE: SQL Statement using variables in PDI
Posted By
Vadim Kalyshkin
02-20-2019 12:30
Found In
Community:
Pentaho
\
view thread
In PDI i guess you can ignore the semi-colon, but anyway $(variable) doesnt work, as it treats everything inside ... as a simple text. If i run the query, i just have no rows provided.
RE: SQL Statement using variables in PDI
Posted By
Vadim Kalyshkin
02-20-2019 12:06
Found In
Community:
Pentaho
\
view thread
looks like it thinks, that $(serial) is the required value. So, it eliminates the call function of $ and treats it just like a simple text.
SQL Statement using variables in PDI
Posted By
Vadim Kalyshkin
02-20-2019 10:15
Found In
Community:
Pentaho
\
view thread
Hello i need to get the data from the database (called employees) which has the columnt (called name) I have defined two variables table and name with the following values table = employees name = john In the table Input Block Ive added the following: select * from $(table) where name = $(name) and ...
Writing the streaming data to the JSON Input
Posted By
Vadim Kalyshkin
12-11-2018 12:00
Found In
Community:
Pentaho
\
view thread
Hello all I try to create the demo working with the MQTT Consumer and have difficulties with writng the message from stream to the JSON Here is the sample message from broker Message [(Event: AirQuality, Time: 2018-12-11T08:53:15.405652Z, PM1_0: 8, PM2_5: 8, PM10: 8)] I specify the JSON Path as $.Event ...
© Hitachi Vantara LLC 2023. All Rights Reserved.
Powered by Higher Logic