Pentaho is just awesome. The fact that it is open source make it really useful for SME that do not have a massive budget. Although its UI may not be flashy and polished, it comes with a suite of powerful tools that can get the job done really well. During recent work on mining data from various database, Oracle 12c seems to be the most problematic to get it working. After experimenting with various configuration, finally got them to talk using JNDI setup.
1. Oracle 12c Configuration
On the Oracle 12c server, the tnsname is configured as follows:
* JUPITER - CDB database
* PDBJUPITER - PDB database
2. Installing Oracle JDBC Driver in Pentaho
Copy the Oracle JDBC driver, ojdbc7.jar from
<ORACLE_INSTALLATION_PATH>/product/12.1.0/dbhome_1/jdbc/lib/
to
<PENTAHO_INSTALLATION_PATH>/lib/
Note: Copy the ojdbc6.jar instead if using JDK 1.6
3. Pentaho DI 5.2 - Spoon Configuration
Locate jdbc.properties file at data_integration/simple_jndi folder. After adding the configuration for Oracle 12c, it becomes as follows:
* PdbJupiter - JNDI name
* pdbjupiter - PDB database
* biadm - A normal user created for PDB
Launch Spoon, go to Tools -> Repository -> Explore -> Connections and add the connection to Oracle 12c as shown in the screen below.
Spoon should now be able to extract and load data from Oracle 12c.
Note: For Oracle 12c, the database url connection has been changed from
jdbc:oracle:thin:@192.168.56.11:1521:<SID>
to
jdbc:oracle:thin:@192.168.56.11:1521/<SERVICE NAME>
Hence, using Native(JDBC) method to connect to Oracle 12c database is not working as it only regconise the first format.
Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.Nice article i was really impressed by seeing this article, it was very interesting and it is very useful for me..
ReplyDeleteAndroid Training in Chennai
Latest Govt Jobs 2016
ReplyDeleteTelangana TS 9096 Police SI Constable Recruitment 2015-16
Such a nice post, Really it helps me a lot
In near future, big data handling and processing is going to the future of IT industry. Thus taking Hadoop Training in Chennai | Big Data Training in Chennai will prove beneficial for talented professionals.
ReplyDeleteReally awesome blog. Your blog is really useful for me.
ReplyDeleteThanks for sharing this informative blog. Keep update your blog.
Oracle Training In Chennai
Nice blog.
ReplyDeleteI really want to configure JDBC.
Please mail me if you can help me thank you. (phaneendhrav@gmail.com)
JDBC for which database?
DeleteBed Bug Exterminator Leesburg VA Just stumbled across your blog and was instantly amazed with all the useful information that is on it. Great post, just what i was looking for and i am looking forward to reading your other posts soon!
ReplyDeleteIP CAmera in jaipur at Rajasthan
ReplyDeleteHome security system in jaipur
Wireless Home Security System in jaipur
Realtime attendance machine in jaipur
cctv camera dealer in jaipur
Boom Barriers system in jaipur at Rajasthan
security system solutions in jaipur
its really great information Thank you sir And keep it up More Post
Rolex Watches Authentic Mens & Ladies Rolex Datejust, President Watches for Sale at JavyEstrella.com.
ReplyDeleteAwesome post and i learn lots of new information from your post. keep sharing. Software Testing Training in Chennai
ReplyDeleteNice Posting...
ReplyDeleteLinux Training in Chennai
It was very useful. Thanks for the post.
ReplyDeleteBest Devops Training in Bangalore
Best Android Training in Bangalore
These servers are manged in pools either from Oracle VM Management Pack or the Oracle VM Manager, but not from both the things.
ReplyDeletesalesforce datawarehouse
That would really be a great help. Thanks for the post.
ReplyDeleteAdvanced Excel classes in Bangalore
Good post.I really inspiring your post..Thanks for sharing.
ReplyDeleteWeblogic Server 12cR2 Training
Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts, have a nice weekend!
ReplyDeletebig-data-hadoop-training-institute-in-bangalore
Thanks For Posting Such an Informative Article.........
ReplyDelete67500/12
Really It's A Great Pleasure reading your Article,learned a lot of new things,we have to keep on updating it,Chicago Immediate care in Chicago.By getting them into one place.Really thanks for posting.Very Thankful for the Informative Post.Really Thanks For Posting.Thanks For Sharing Such an Valuable Info.
ReplyDeleteExcellent article, Cool, Looking ahead to reading a lot. Sensible article USMLE Thanks for posting.
ReplyDeleteThis Blog Provides Very Useful and Important Information. I just Want to share this blog with my friends and family members. digital transformation consulting Thanks for posting.
ReplyDeletethanks for the informative and useful stuff........
ReplyDeleteJust News To U 99
This is really worth reading. I'm gaining a lot of knowledge from your posts. Keep us updated with more such articles.
ReplyDeleteJavaScript Training in Chennai
JavaScript Course in Chennai
Embedded System Course Chennai
Embedded Training in Chennai
Spark Training in Chennai
Spark Training Academy Chennai
JavaScript Training in T Nagar
JavaScript Training in Anna Nagar
I can see your hardwork in this article, great work keep doing.
ReplyDeleteLoadrunner Training in Chennai
JAVA Training in Chennai
Hadoop Training in Chennai
Selenium Training in Chennai
German Classes in chennai
Software Testing Training in Chennai
Software testing training institute in chennai
Software testing Training in Porur
Разноцветная светодиодная лента или как ее еще называют светодиодная лента rgb наверое одно из лучших изобретений которое придумали люди, очень забавная штука.
ReplyDeleteAnd indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.
ReplyDeleteSOFTWARE TRAINING IN CHENNAI
POWERBI TRAINING IN CHENNAI
CCNA TRAINING IN CHENNAI
ANDROID TRAINING IN CHENNAI
The article is very interesting and very understood to be read, may be useful for the people. I wanted to thank you for this great read!! I definitely enjoyed every little bit of it. I have to bookmarked to check out new stuff on your post. Thanks for sharing the information keep updating, looking forward for more posts..
ReplyDeleteKindly visit us @
Madurai Travels
Best Travels in Madurai
Cabs in Madurai
Tours and Travels in Madurai
Home Mart is a site about Home Improvement, Furniture, Home Appliances and many more.
ReplyDeleteCheck out the best
bookshelves
balance bike
I believe there are many more pleasurable opportunities ahead for individuals that looked at your site
ReplyDeletelinux training in chennai | linux course in chennai| best linux training in chennai |linux certification in chennai
The article is so informative. This is more helpful for our
ReplyDeleteselenium training in chennai
selenium online courses best selenium online training
selenium testing training
selenium classes
Thanks for sharing.
Great Article
ReplyDeleteFinal Year Project Domains for CSE
Final Year Project Centers in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
I´ve been thinking of starting a blog on this subject myself .....
ReplyDeleteThanks for sharing...
ReplyDeleteVery good article
good post! keep share.
ReplyDeleteiot training in chennai
internship for automobile engineering students in chennai
internship for mechanical engineering students in chennai
r programming training in chennai
Thanks for sharing information. I really appreciate it.
ReplyDeletekeep share.
ReplyDeletejs max int
c++ program to print pyramid using *
why do you consider yourself suitable for this position
hack whatsapp ethical hacking
databricks interview questions
paramatrix aptitude questions and answers
which is the closest approximation to the product 0.3333
a watch was sold at a loss of 10
ip spoofing tutorial
advantages of packages in java
thank you for your blog
ReplyDeleteKenya Shared Web Hosting
Dominican Republic Web Hosting
Dominican Republic Jordan Web Hosting
Dominican Republic Kazakhstan Web Hosting
Dominican Republic Web Hosting Korea
Dominican Republic Web Hosting Timor Lestes
Dominican Republic Costa Rica Web Hosting
Dominican Republic Hong Kong Web Hosting
Dominican Republic Slovakia Web Hosting
ReplyDeleteDominican Republic Bahrain Web Hosting
Dominican Republic Web Hosting India
Dominican Republic Iran Web Hosting
Dominican Republic Moldova Web Hosting
Dominican Republic Turkey Web Hosting
This is so great. Thanks for sharing....
ReplyDeleteWonderful post, This article have helped greatly continue writing ..
ReplyDeleteNice blog, it’s so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job. Thank you for this wonderful sharing with us. Keep Sharing.
ReplyDeletevery nice post and useful information........
ReplyDeleter programming training in chennai
internship in bangalore for ece students
inplant training for mechanical engineering students
summer internships in hyderabad for cse students 2019
final year project ideas for information technology
bba internship certificate
internship in bangalore for ece
internship for cse students in hyderabad
summer training for ece students after second year
robotics courses in chennai
internship in chennai for ece students with stipend
ReplyDeleteinternship for mechanical engineering students in chennai
inplant training in chennai
free internship in pune for computer engineering students
internship in chennai for mca
iot internships
internships for cse students in
implant training in chennai
internship for aeronautical engineering students in bangalore
inplant training certificate
very good post...
ReplyDeleteinternship report on python
free internship in chennai for ece students
free internship for bca
internship for computer science engineering students in india
internships in hyderabad for cse students 2018
electrical companies in hyderabad for internship
internships in chennai for cse students 2019
internships for ece students
inplant training in tcs chennai
internship at chennai
IT IS A BEST ONE FOR SEARCHING....
ReplyDeletekaashiv infotech internship in bangalore
internship for ece
mba internship
final year project proposal for information technology
internships in chennai for ece students
companies for industrial visit in chennai for cse students
internship in bangalore for eee
internship in chennai
inplant training certificate format for mechanical engineering
internship for aeronautical engineering students in chennai
Thanks for sharing...
ReplyDeleteVery good Keep it up.
3d-modeler-resume-samples
ReplyDelete3d modeler resume samples
accounting-assistant-resume-sample
accounting-clerk-resume-sample
accounting-manager-resume-samples
account-manager-resume-examples
accounts-payable-resume-sample
admin-manager-resume-samples
advocate-resume-sample
advocate-resume-sample
excellent.....
ReplyDeleteapache solr resume sample
apache spark sample resume
application developer resume samples
application support engineer resume sample
asp dotnet mvc developer resume
asp net core developer resume
asp net developer resume samples
assistant accountant cv sample
assistant accountant resume
assistant accountant resume sample
excellent.....
ReplyDeleteapache solr resume sample
apache spark sample resume
application developer resume samples
application support engineer resume sample
asp dotnet mvc developer resume
asp net core developer resume
asp net developer resume samples
assistant accountant cv sample
assistant accountant resume
assistant accountant resume sample
This comment has been removed by the author.
ReplyDeletenice.....it is use full...
ReplyDeleteaeronautical internship in india
free internship in chennai for mechanical engineering student
architectural firms in chennai for internship
internship in coimbatore for eee
online internships for cse students
mechanical internship certificate
inplant training report
internships in hyderabad for cse
internship for mba students in chennai
internship in trichy for cse
good.....
ReplyDeletekaashiv infotech pune
industrial training report for electronics and communication
internships for cse
internship for automobile engineering students in bangalore
internships in bangalore for eee students
internship for civil engineering students in chennai 2019
internship in automobile companies in chennai
robotics chennai
final year projects for information technology
good...nice...
ReplyDeleteassistant-director-resume-format
assistant-director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
good..nice..
ReplyDeleteinternships in bangalore for ece students 2019
internship for aeronautical engineering students in bangalore
kaashiv infotech chennai
internship for ece students in bangalore 2018
internship in chennai for eee with stipend
internship in chennai for mechanical engineering students
kaashiv infotech hyderabad
kaashiv infotech internship
internship in chennai for cse 2019
internship in aeronautical engineering
Nice blog!!!
ReplyDeleteInternships in pune for computer science students
Internships in pune for computer science students
Inplant training certificate format
Internships in bangalore for ece students
Industrial training for electronics and communication engineering students
Internship for computer science students in bangalore
Internship for ece students
Mba internship in chennai
Inplant training in chennai for ece
Internship in nagpur for cse
Hello Admin!
ReplyDeleteThanks for the post. It was very interesting and meaningful. I really appreciate it! Keep updating stuffs like this. If you are looking for the Advertising Agency in Chennai | Printing in Chennai , Visit Inoventic Creative Agency Today..
good..nice..
ReplyDeleteassistant-director-resume-format
assistant-director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
excellent...!!!
ReplyDeleteSelenium training in chennai
Industrial visit in chennai
Internship
Internships in bangalore for cse students 2019
Free internship in chennai for cse students
Network security projects for cse
Ccna course in chennai
Inplant training in chennai for cse
Inplant training for eee students
Kaashiv infotech chennai
good... nice... very useful..
ReplyDeleteassistant-director-resume-format
director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
ReplyDeletefilm-director-resume
finance-and-accounting-manager-resume-samples
finance-director-resume-examples
fire-safety-officer-resume-sample
fleet-maintenance-manager-resume-samples
format-for-resume-writing
fresher-computer-engineers-resume-sample
fresher-hr-resume-sample
fresher-hr-resume-sample-2
fresher-lecturer-resume
Keep sharing the post like this...
ReplyDeleteThank you for such wonderful post and Really useful content. I want more updates...
ReplyDeleteLinux Course in Chennai
best linux training in chennai
Spark Training in Chennai
Appium Training in Chennai
Power BI Training in Chennai
JMeter Training in Chennai
Placement Training in Chennai
Soft Skills Training in Chennai
Linux Training in T Nagar
Linux Training in Velachery
Hi, Very nice article. I hope you will publish again such type of post. Thank you!
ReplyDeleteCorporate gifts ideas | Corporate gifts
Corporate gifts singapore | Corporate gifts in singapore
Promotional gifts singapore | Corporate gifts wholesale Singapore
ReplyDeleteThanks for sharing such a great blog
Vermicompost manufacturers in Tamilnadu | Vermicompost in Tamilnadu
Vermicompost Manufacturers | Vermicompost Suppliers
Vermicompost in Coimbatore | Vermicompost manufacturers in Chennai
Vermicompost in chennai | Best Vermicompost in chennai
.
Great explanation to given on this post and i read our full content was really amazing,then the this more important in my part of life. The given information very impressed for me really so nice content.
ReplyDeleteAWS training in chennai | AWS training in anna nagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery
Hi, Very nice article. I hope you will publish again such type of post. Thank you!
ReplyDeleteCorporate gifts ideas | Corporate gifts
Corporate gifts singapore | Corporate gifts in singapore
Promotional gifts singapore | Corporate gifts wholesale Singapore
leather corporate gifts singapore | t shirts supplier singapore
thumb drive supplier singapore | business card holder singapore
corporate gifts supplier | customized corporate gifts singapore
corporate gifts supplier singapore
Very informative post. Social media will give the loads of opportunities to grow your business and helps you attract the targeted audiences (both B2B and B2C). Sharing more infographic content on social media will give more visibility.Thanks for sharing...keep update...
ReplyDeletei need some more infomation
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
ReplyDeleteBig Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery
Thank you for your valuable help. This blog really helped me a lot. I really appreciate your efforts.
ReplyDeleteOracle Training | Online Course | Certification in chennai | Oracle Training | Online Course | Certification in bangalore | Oracle Training | Online Course | Certification in hyderabad | Oracle Training | Online Course | Certification in pune | Oracle Training | Online Course | Certification in coimbatore
Nice blog thank you for sharing
ReplyDeleteData science Training in bangalore
Aws Training In Bangalore
Hadoop Training In Bangalore
SUPER ARTICLE
ReplyDeleteinternship in chennai for mechanical engineering
internship in chennai for mba finance
internship in bmw chennai
internship jobs in chennai
internship in chennai for civil engineering students
internship in chennai for mba hr
internship in chennai for eee students
internship for biotechnology in chennai
internship in chennai for bba students
internship in chennai for engineering students
Really, it’s a useful blog. Thanks for sharing this information.
ReplyDeleteIonic Online Course
Kotlin Online Course
social media marketing Online Training
React Native Online Training
R programming Training in Chennai
Xamarin Course in Chennai
Ionic Course in Chennai
Nice blog, Thanks for sharing this useful information.
ReplyDeleteMobile Application Testing Online Training
Mobile App Development Online Course
Mobile App Development Courses in Chennai
Google Analytics Online Course
Google Analytics Training in Chennai
Content Writing Course in Chennai
Online Content Writing Course
Thanks for sharing this information. I really appreciate it.
ReplyDeleteIphone service center in tnagar | Iphone service center in chennai
Lenovo mobile service center in Tnagar | Lenovo Mobile service center in chennai
Moto service center in t nagar | Motorola service center in t nagar
Moto Service Center in Chennai | Motorola Service Center in chennai
wonderful article contains lot of valuable information. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteThis article resolved my all queries.good luck an best wishes to the team members.continue posting.learn digital marketing use these following link
Digital Marketing Course in Chennai
Such a great blog, thanks for sharing the blog.
ReplyDeleteielts preparation tips
how to become an ethical hacker
stress interview questions
how much java is required for selenium
ethical hacking interview questions
hacking books
Nice post! Thanks for your great content and I obtain a huge of knowledge from your best post...
ReplyDeleteSelenium with C# Training
Selenium with Python Training
Selenium with Java Training
Learn Selenium with Java Training
Interesting stuff to read. Keep it up.Adidas showroom in madurai
ReplyDeleteWoodland showroom in madurai | Skechers showroom in Madurai
Puma showroom in madurai
Thanks for sharing a useful knowledge-sharing blog.
ReplyDeleteIt helps in understanding and increase in knowledge.
Best Regards,
Prestashop addons
Prestashop modules
Prestashop addons blogs
Magento extensions
PrestaShop SEO Structured Data Schema Markup & Rich Snippet
PrestaShop Custom HTML inside Head Tag on Selected Pages
PrestaShop SEO Google Hreflang Tag for Multilingual Store
PrestaShop Product Extra Tabs
PrestaShop Social Login – Sign-In using Social Networks
PrestaShop Custom Banners for Selected Categories and Languages
PrestaShop Social Media Side Bar Links Buttons on All Pages
PrestaShop SEO Open Graph & Twitter Card Tags Generator
Magento Geolocation Redirect Visitor Country
Very Informative blog thank you for sharing. Keep sharing.
ReplyDeleteBest software training institute in Chennai. Make your career development the best by learning software courses.
Docker Training institute in Chennai
android course in chennai
power bi training in chennai
I really enjoyed this post
ReplyDeletePackers and Movers in Chennai | Packers and Movers in Trichy
Packers and Movers in Theni | Packers and Movers in Karur
Packers and Movers in Madurai
Those guidelines additionally worked to become a good way to
ReplyDeleterecognize that other people online have the identical fervor like mine
to grasp great deal more around this condition..
dba course in chennai
java training institute in chennai
node js course in chennai
Excellent post. Thank you for sharing
ReplyDeleteSpanish Language Learning| Spanish Language
Amazing write-up! Best Murukku Machine in Tamilnadu
ReplyDeleteLow Cost Murukku Machine in Tamilnadu
Automatic Murukku Machine in Tamilnadu
Kai Murukku Machine in Tamilnadu
Chakli Making Machine in Tamilnadu
Western Region, which introduced with it her relocation to the town of Las Vegas, where she at present resides. In 2020, Solsiree accepted the supply to be Director of Product Compliance for the massive slot manufacturer Light & Wonder . Currently, she works there with a wonderful staff of pros that gives services across the 빅카지노 globe.
ReplyDelete