I am using jdbc connection and i am passing parameters with example ${sample_db_connection} and that parameters has been defined in server in a text file as sample_db_connection=localhost and i want to pass the text file in the job step so that whenever the job ran and it found this parameter ,automatically it will take the value defined in text file.
In pentaho..How to pass a text file which contains all the definition of the connection parameters in the job?
628 Views Asked by Coding_line At
1
There are 1 best solutions below
Related Questions in PENTAHO
- MDX date range with NON EMPTY clause is not slicing the data for the range
- hide a sub report containing a chart pentaho
- Generating a dynamic date based on a row number using pentaho pdi
- Expired time for acquiring lock pentaho
- "Operation in progress..." Never Ends When Previewing Rows in Kettle Spoon via Salesforce
- How to use component javascript in the Pentahoo Data Integration
- Adding column to existing pentaho reports
- Function in postgres taking too long and how to trace back how many records has been updated
- Report ,subreport pentaho
- Pentaho 5.3 - How to read a property in PRPT files
- Dynimically load table text,Xml values into ETL Pentaho JOB
- pentaho can't access by chrome
- Pentaho report designer bulk change file location in subreports
- Stop Kettle/Spoon from crashing with one line R script
- Get rows from result step and Get Varaibles usage in Pentaho data Integeration
Related Questions in DATA-WAREHOUSE
- Big data with spatial queries/indexing
- Joining date and time field in Tableau
- Talend Open Studio for Big Data
- spark stream and spark sql with data warehouse
- Errors in the OLAP storage engine: The attribute key cannot be found when processing
- Anchor modeling - tie: make first role?
- Is star schema still necessary for a big-data-warehouse?
- How to batch export raw data from Omniture (SiteCatalyst or Adobe Analytics)
- Omniture Data Warehouse Segments Issue
- Plotting data cubes
- SQL Server Storing DateTime as Integer
- When we use Datamart and Datawarehousing?
- How to merge two or more queries with different where conditions? I have to reuse the code which is being used in 1st where code
- Structural difference between Relational Databases vs. Multidimensional Databases
- Shell Script to Validate Filename
Related Questions in KETTLE
- Generating a dynamic date based on a row number using pentaho pdi
- Expired time for acquiring lock pentaho
- "Operation in progress..." Never Ends When Previewing Rows in Kettle Spoon via Salesforce
- Stop Kettle/Spoon from crashing with one line R script
- Pentaho: Update a record of database using public parameter
- How to integrate Kettle with H2
- How upload file to Pentaho User Console server?
- Kettle, JDBC, MySQL, SSL: Could not Connetct to database
- how to make pentaho kette trust all self-signed certs?
- Kettle lauched inside java function change system properties
- Missing table input task in kettle GUI
- XML Join Step in Pentaho Kettle is very low in Performance
- Regular expression to delete XML element names
- How to launch two jobs simultaneously after the execution of one Job in Pentaho
- Kettle operation window get stuck at Linux OS，and always not responding
Related Questions in PDI
- Get rows from result step and Get Varaibles usage in Pentaho data Integeration
- Pentaho: Update a record of database using public parameter
- How to avoid rolling execution of a job(pentaho data integration)
- Java expression for Pentaho Kettle
- Scheduling a job in pentaho 5.1 setting logging information to Email
- Pentaho Data Integration commercial costs + azure hosting
- How to pass fields to pentaho update step using metadata injector?
- Remove duplicated row from 2 tables in different database
- Pentaho User defined Java Class - Datatype Conversion Error
- lookup_Pentaho data Integration
- PDI transformation does not send messages to Kafka server
- How to delete documents in a mongodb collection using mongodb delete step in Pentaho
- how to override the numberlong() when mongodb output writes documents in mongodb
- How to store a variable from one line for use in later lines in Pentaho kettle?
- In pentaho..How to pass a text file which contains all the definition of the connection parameters in the job?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You need to create a KTR file using "Property Input" as the input step and "Modified Java Script" Step to define the key value mapping. Check the image below:
Define your filename in the input step. In the JS step, you can use "setVariable" function to define the key-value mapping.
Once this job is executed at the start, pentaho will set the variables for all the connection.
Hope i have understood the question correctly and this is what you are looking for !! :)