{"id":4975,"date":"2023-12-06T08:29:09","date_gmt":"2023-12-06T08:29:09","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=4975"},"modified":"2023-12-06T10:22:17","modified_gmt":"2023-12-06T10:22:17","slug":"pentaho-data-integration-with-postgresql","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/","title":{"rendered":"Pentaho Data Integration with PostgreSQL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-3d3b41f3b6763d43288a4a741ab5ca5f wp-block-paragraph\">Pentaho Data Integration (PDI) serves as a robust ETL (Extract, Transform, Load) tool, playing a pivotal role in handling the complexities of data ingestion pipelines. As organizations accumulate vast amounts of data from diverse sources and in different formats, orchestrating seamless data movement becomes essential for informed decision-making. PDI stands out as a valuable solution, providing a comprehensive platform to design, deploy, and manage data pipelines efficiently. With its user-friendly interface and a wide range of transformation steps and connectors, PDI facilitates the extraction, transformation, and loading of data across various stages of the pipeline. Importantly, PDI is highly adaptable, making it well-suited for creating configurable data ingestion pipelines that can accommodate diverse data structures and formats. In a series of upcoming blogs, I will delve into the intricacies of configuring end-to-end data ingestion pipelines using PDI. The focus will be on demonstrating how to leverage PDI&#8217;s capabilities to handle the challenges posed by the increasing volume and diversity of data, particularly emphasizing its application in conjunction with PostgreSQL databases, ensuring a robust foundation for efficient data management and analytics.<br><br>Feel free to explore the previously published blogs on Data Engineering by my colleagues:<br><a href=\"https:\/\/test.opensource-db.in\/wp1\/building-an-efficient-data-pipeline-with-postgresql-and-talend-open-studio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Building an Efficient Data Pipeline with PostgreSQL and Talend OpenStudio<\/a><br><a href=\"https:\/\/test.opensource-db.in\/wp1\/data-engineering-with-hydra-the-basics\/\" target=\"_blank\" rel=\"noreferrer noopener\">Data Engineering with Hydra<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Installation :&nbsp;<\/strong><\/h2>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-945c994342a221101fe78a6a46e4f06a wp-block-paragraph\">The basic requirements to install Pentaho Data Integration on Ubuntu Operating System&nbsp; are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\">&nbsp;&nbsp;&nbsp;&nbsp;Pentaho Data Integration Community&nbsp;<\/li>\n\n\n\n<li class=\"has-medium-font-size\">&nbsp;&nbsp;&nbsp;&nbsp;Edition Ubuntu 16 or above&nbsp;&nbsp;<\/li>\n\n\n\n<li class=\"has-medium-font-size\">&nbsp;&nbsp;&nbsp;JDK 11 and above (Java Development Kit)<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-1: Downloading the Pentaho Data Integration (PDI\/Kettle) Software<\/strong><\/h4>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-443ffaa4b9841b9b752fa812136c236e wp-block-paragraph\">Download the PDI-CE from SourceForge<a href=\"https:\/\/sourceforge.net\/projects\/pentaho\/files\/Pentaho%209.0\/\"> <em>link<\/em><\/a> at the time of PDI\u2019s latest version is 9.4, you can download the latest stable version as per your requirements.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-2: Extracting the zip file<\/strong><\/h4>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-4aefbbf86f8a188e8c9b1255c6ff3470 wp-block-paragraph\">&nbsp;Extract the downloaded zip file which will be in the Downloads folder . Right click the file and choose the &#8216;Extract Here&#8217; if you want it to get extracted in the downloads folder.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-3: Checking Java Availability<\/strong><\/h4>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-783457f2c108748fe337c477dd66ce51 wp-block-paragraph\">Since Pentaho is written on Java, PDI tool requires Java to run;<\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-a8ac678e81fb6567e965a83fc3a04a15 wp-block-paragraph\">&nbsp;<strong>java -version<\/strong><\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-9f1e2a4f67c74f49c14e419198575c06 wp-block-paragraph\">&nbsp;if you don\u2019t already have a Java runtime environment(JRE) installed, download and install JRE using the following commands:<\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-eabe44c883b96917746f8d375ee2bf78 wp-block-paragraph\"><strong>sudo apt-get update<\/strong><\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-f8875a7083c67625396e0724aec9922d wp-block-paragraph\"><strong>sudo apt-get install openjdk-11-jre<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-4: Launching Spoon<\/strong><\/h4>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-65eace16f2c06dd34ecb823fa7242e1c wp-block-paragraph\">The last step would be to launch the Spoon application. For this, go to folder where we have extracted pdi (data-integration folder) earlier in step-2. Right click within this folder and select &#8216;Open Terminal&#8217; and type the below command:<\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-16f2944c813943e2dbc34265d5ba4a4a wp-block-paragraph\">.\/spoon.sh<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How to connect with Postgresql Database:<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\">Before connecting to spoon we need to authenticate ip address of the pentaho server in pg_hba.conf&nbsp; file <code>\/etc\/postgresql\/*\/main\/pg_ident.conf<\/code><\/li>\n\n\n\n<li class=\"has-medium-font-size\"> we need to change the isten address from \u2018local host\u2019 to \u2018*\u2019in postgresql.conf file <code>\/etc\/postgresql\/*\/main\/postgresql.conf<\/code>. Locate the line: <em>#listen_addresses = \u2018localhost\u2019<\/em> and change it to <code>*<\/code><\/li>\n\n\n\n<li class=\"has-medium-font-size\">Restart the Postgresql server&nbsp;<\/li>\n\n\n\n<li class=\"has-medium-font-size\">Open Spoon and create a new transformation.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-2f7004a9fef08c0dff81b503bf1ee7e9 wp-block-paragraph\">         Click on the <strong>View <\/strong>option that&nbsp; appears in the upper-left corner<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-1024x580.png\" alt=\"\" class=\"wp-image-4977\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-1024x580.png 1024w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-300x170.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-768x435.png 768w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-1536x869.png 1536w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-175x99.png 175w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-141x80.png 141w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-394x223.png 394w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-915x518.png 915w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43-1240x702.png 1240w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-16-28-43.png 1539w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ufffc<br>\ufffc<\/p>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-56cfb8462a71f324a3dc70ccef0a5c1d wp-block-paragraph\">Fill the Database Connection dialog window.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-1024x580.png\" alt=\"\" class=\"wp-image-4978\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-1024x580.png 1024w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-300x170.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-768x435.png 768w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-1536x869.png 1536w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-175x99.png 175w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-141x80.png 141w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-394x223.png 394w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-915x518.png 915w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14-1240x702.png 1240w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-33-14.png 1539w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-f18042cbb111ed2c58574b4265e0d092 wp-block-paragraph\">Click on the Test button. The following window shows up:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-1024x580.png\" alt=\"\" class=\"wp-image-4979\" style=\"width:840px;height:auto\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-1024x580.png 1024w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-300x170.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-768x435.png 768w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-1536x869.png 1536w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-175x99.png 175w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-141x80.png 141w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-394x223.png 394w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-915x518.png 915w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29-1240x702.png 1240w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/Screenshot-from-2023-12-05-18-37-29.png 1539w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\">Click on <strong>OK <\/strong>to close the test window.<\/li>\n\n\n\n<li class=\"has-medium-font-size\">Click on <strong>OK <\/strong>again to close the database definition window. A new database connection is added to the tree.<\/li>\n\n\n\n<li class=\"has-medium-font-size\">Right-click on the database connection and click on <strong>Share<\/strong>. The connection is available in all transformations you create from now onwards.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next steps :&nbsp;<\/strong><\/h2>\n\n\n\n<p class=\"has-black-color has-text-color has-link-color has-medium-font-size wp-elements-e3ca347df387c3a4e1ec04af69fd6c78 wp-block-paragraph\">Embarking on a comprehensive Data Engineering journey, the integration of PostgreSQL with Pentaho Data Integration (PDI) marks just the initial step. Throughout the upcoming series of blog posts, I will guide you through the intricacies of the complete data ingestion process. This journey will provide insights into seamlessly navigating end-to-end processes with Pentaho PDI while specifically focusing on optimizing workflows with PostgreSQL. In the forthcoming blog, our exploration will delve deeper into the sophisticated realm of Change Data Capture (CDC). This pivotal feature ensures that our data pipelines are not only capable of handling static datasets but are also adept at capturing and processing real-time changes within the PostgreSQL database. By unraveling the intricacies of CDC, we aim to help you with the knowledge to build dynamic, responsive, and intelligent data solutions that align with the evolving nature of your PostgreSQL data sources. Stay tuned for an insightful exploration of CDC and its transformative impact on data integration workflows.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Pentaho Data Integration (PDI) serves as a robust ETL (Extract, Transform, Load) tool, playing a pivotal role in handling [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":4985,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52,23,42,89],"tags":[81],"class_list":["post-4975","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-customer-success","category-postgresql-14","category-postgresql-15","category-postgresql-16","tag-data-engineering"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pentaho Data Integration with PostgreSQL - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pentaho Data Integration with PostgreSQL - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction Pentaho Data Integration (PDI) serves as a robust ETL (Extract, Transform, Load) tool, playing a pivotal role in handling [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-06T08:29:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T10:22:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"945\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Akhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"Pentaho Data Integration with PostgreSQL\",\"datePublished\":\"2023-12-06T08:29:09+00:00\",\"dateModified\":\"2023-12-06T10:22:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/\"},\"wordCount\":727,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png\",\"keywords\":[\"data-engineering\"],\"articleSection\":[\"Customer Success\",\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/\",\"name\":\"Pentaho Data Integration with PostgreSQL - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png\",\"datePublished\":\"2023-12-06T08:29:09+00:00\",\"dateModified\":\"2023-12-06T10:22:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png\",\"width\":1800,\"height\":945},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pentaho Data Integration with PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pentaho Data Integration with PostgreSQL - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Pentaho Data Integration with PostgreSQL - OpenSource DB","og_description":"Introduction Pentaho Data Integration (PDI) serves as a robust ETL (Extract, Transform, Load) tool, playing a pivotal role in handling [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-12-06T08:29:09+00:00","article_modified_time":"2023-12-06T10:22:17+00:00","og_image":[{"width":1800,"height":945,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png","type":"image\/png"}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"Pentaho Data Integration with PostgreSQL","datePublished":"2023-12-06T08:29:09+00:00","dateModified":"2023-12-06T10:22:17+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/"},"wordCount":727,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png","keywords":["data-engineering"],"articleSection":["Customer Success","PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/","url":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/","name":"Pentaho Data Integration with PostgreSQL - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png","datePublished":"2023-12-06T08:29:09+00:00","dateModified":"2023-12-06T10:22:17+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png","width":1800,"height":945},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/pentaho-data-integration-with-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Pentaho Data Integration with PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",1800,945,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",1800,945,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",1800,945,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5-300x158.png",300,158,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5-1024x538.png",1024,538,true],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5-1536x806.png",1536,806,true],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",1800,945,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",1200,630,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",870,457,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",600,315,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/12\/image-5.png",600,315,false]},"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/business\/customer-success\/\" rel=\"category tag\">Customer Success<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-16\/\" rel=\"category tag\">PostgreSQL 16<\/a>","rttpg_excerpt":"Introduction Pentaho Data Integration (PDI) serves as a robust ETL (Extract, Transform, Load) tool, playing a pivotal role in handling [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=4975"}],"version-history":[{"count":8,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4975\/revisions"}],"predecessor-version":[{"id":4991,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4975\/revisions\/4991"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/4985"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=4975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=4975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=4975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}