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?
629 views Asked by Coding_line At
1
There are 1 answers
Related Questions in PENTAHO
- Git Not In Sync with Local Branch
- How to write a blob file to local filesystem using PDI?
- Where I download the Pentaho Community Edition, link breadk on sourceforge
- Pentaho PDI || Windows Current User
- Slowly Changing Dimension Type 2
- Json is sending Überlegung character convert in pentaho different format
- Amazon S3 multi part upload error using Pentaho 9.3
- Multiline parsing in Fluent-Bit for pentaho jobs on kubernetes
- Set Variable In a Pentaho Loop
- Get row number from stream to perform concat
- pass parameters to database connection in pentaho using jenkins freestyle job
- Troubleshooting 'No such file or directory' Error for Network Paths in Pentaho Server Job Execution
- Pentoho How to check ,If at least one row is LDAP is 0 with same user mutiple times
- Problems returning csv data, pentaho reading failure
- Pentaho Unable to access Remote Excel file
Related Questions in DATA-WAREHOUSE
- How to blind data in data warehouse when sending from preanonymized layer to anonymized layer while keeping referential integrity of all key columns
- Run Pyspark job using Matillion
- the right grain of a fact table in data warehouse
- Model the number of available spots in dimension or fact table?
- What is the most efficient way to generate a change data set given two SQL Server backup files?
- Does it make sense to use an IDENTITY column in a raw layer?
- Power BI star (constellation) schema: 2 fact tables with relation between each other
- Rolling Period Table or CTE
- Representation of sequential rules in data mining (sequence pattern mining)
- Snowflake Bulk Inserts vs. Single Row Inserts
- Data not showing in power bi report
- Data Warehouse to Power BI Desktop
- Error initialize process greenplum major upgrade 5.29.12 to 6.25.2 on centos 7
- Modify column type in Parquet file with ruby (using parquet Gem)
- Translating Snowflake warehouse usage to BigQuery
Related Questions in KETTLE
- Transform XML with meta columns to csv in PDI
- Get row number from stream to perform concat
- How to add condition in Pentaho Spoon
- Pentaho: Multiple excel in folder to a excel
- Issue with Channel Log Tables in Pentaho Data Integration V7: Works in Manual Execution but Not in Nightly Batch
- How to loop through date variables in PDI?
- How to delete rows which were deleted in source table (Pentaho data integration)
- Unable to read variable value from kettle.properties file
- Pentaho Kettle PDI - Use ETL Metadata injection with data validator
- Bad accents and "ñ" in my postgres database
- Pentaho kettle embedded transformation error handling in JAVA application
- Pentaho metastore location when connecting to repository
- Kettle's spoon.bat can't open
- How to add new column to stream in Pentaho DI, without blocking the stream, new column value is not constant
- Run Pentaho Job or transformation on Carte Server via command line
Related Questions in PDI
- How to write a blob file to local filesystem using PDI?
- Pentaho PDI || Windows Current User
- Transform XML with meta columns to csv in PDI
- Pentaho: Multiple excel in folder to a excel
- Issue with Channel Log Tables in Pentaho Data Integration V7: Works in Manual Execution but Not in Nightly Batch
- How to loop through date variables in PDI?
- How to delete rows which were deleted in source table (Pentaho data integration)
- Connection between pentaho and mysql is reset
- Issue running Python Executor Step Pentaho
- How to extract ObjectId to timestamp using mongodb function gettimestamp() in Pentaho Data Integrator
- Aborting job in pentaho without error message in log
- Pentaho PDI ETL - Get file with FTP not working
- Get Transformation details using a table name in PDI Pentaho
- Pentaho PDI nullpointer exception importing data from TXT file
- How to Read a multi nested JSON file with Pentaho Spoon 6 JSON Input
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?
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)
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 !! :)