Tutorials about data domain including Data warehousing, Database, ETL, ELT, Data Models, Data Analysis, Big Data, Business Intelligence and etc,noreply@blogger.com (Lilantha Lakmal)Mon, 29 Jun 2026 11:07:56 +0300Blogger http://www.blogger.com22125http://datatutors.blogspot.com/en-usnoTutorials about data domain including Data warehousing, Database, ETL, ELT, Data Models, Data Analysis, Big Data, Business Intelligence and etc,noreply@blogger.comhttp://datatutors.blogspot.com/2019/06/how-to-install-oracle-19c.html19cfeaturedInstallOraclenoreply@blogger.com (Lilantha Lakmal)Fri, 28 Jun 2019 11:39:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-5736325667232060551 Introduction Oracle Database 19c builds upon the innovations of previous releases such as Multitenant, In-Memory, JSON support, Sharding and many other features that enable Oracle’s Autonomous Database Cloud Services. This latest release of the world’s most popular database also introduces new functionality, providing customers with a multi-model enterprise-class database for all their 0http://datatutors.blogspot.com/2018/07/install-ibm-infosphere-datastage.htmlDataStageETLfeaturedInstallWindowsnoreply@blogger.com (Unknown)Tue, 10 Jul 2018 12:56:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-4361547676287868904 Datastage is an ETL tool which extracts data, transform and load data from source to the target. The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc. DataStage facilitates business analysis by providing quality data to help in gaining business intelligence. Datastage is used in a large 0http://datatutors.blogspot.com/2018/06/open-source-etl-tools_20.htmlELTETLfeaturednoreply@blogger.com (Lilantha Lakmal)Wed, 20 Jun 2018 17:08:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-742153771148002988 Now a day there are many ETL tools on the market. We can categorize those as Open Source, Commercial and Modern ETL tools. In this short article, I will discuss open source ETL tools. Open source ETL Tools Open source ETL tools are most popular in the data integration industry and play a big roll in industry. Those tools are coming with a lot of Features and also there are large 0http://datatutors.blogspot.com/2018/05/talend-open-studio-for-mater-data.htmlConfigurationsfeaturedMDMTalendWindowsnoreply@blogger.com (Lilantha Lakmal)Wed, 9 May 2018 12:21:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-7305913131186394233 Introduction What is the master data? Master data represents the business objects which are agreed on and shared across the enterprise. It can cover relatively static reference data, transactional, unstructured, analytical, hierarchical and metadata. It is the primary focus of the Information Technology (IT) discipline of Master Data Management (MDM). While master data is often 0http://datatutors.blogspot.com/2018/05/how-to-install-talend-data-preparation.htmlfeaturedMDGMDMTalendToolsWindowsnoreply@blogger.com (Lilantha Lakmal)Wed, 11 Apr 2018 15:18:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-932353740799399869 Introduction. Now, with Talend Data Preparation, you can access, cleanse and prepare data in a simple, intuitive way. First, when you enter the tool, it prompts you with a pop-up guide to import your Excel file or other types of data sources. Then you select that same spreadsheet and in just a few clicks you can cleanse, standardize, complete fields and filter the data by region, job title, 0http://datatutors.blogspot.com/2018/03/odi-table-to-table-mapping-part-3.htmlELTETLfeaturedODInoreply@blogger.com (Lilantha Lakmal)Mon, 26 Mar 2018 12:26:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-7650737679660564968 In this tutorial, I will discuss ODI Mapping. ODI Mapping. Mappings are the logical and physical organization of your data sources, targets, and the transformations through which the data flows from source to target. You create and manage mappings using the mapping editor, a new feature of ODI 12c. Before this, you may read part-1 and part-2 How to create ODI mapping You can create ODI 0http://datatutors.blogspot.com/2018/03/odi-12c-table-to-table-mapping-part-2.htmlELTETLfeaturedODInoreply@blogger.com (Lilantha Lakmal)Wed, 14 Feb 2018 14:37:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-6612339635501325979 Introduction This is a part 2 of table to table mapping process. I have discussed about Source and target connection creation process in part 1. In this section I will discuses about data-store, models and reverse engineering in ODI. Data Store A Model is the description of a set of datastores. It corresponds to a group of tabular data structures stored in a data server. A model is based on0http://datatutors.blogspot.com/2016/09/odi-12c-source-and-target-connection.htmlConfigurationsELTETLfeaturedODInoreply@blogger.com (Lilantha Lakmal)Wed, 17 Jan 2018 09:00:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-4628338254724192709 Introduction In my last discussion I had discussed with you that how to install ODI 12c. Now I will discuss with you that how to create connection to source and target data source, It  may be RDBMS, Excel File, TXT file, Hadoop Data, SAP and ect. Configuration 1. Open ODI 2. Click “ Connect to Repository”. 3. Connect to work repository. 4. Go to topology tab and and right 0http://datatutors.blogspot.com/2018/01/what-is-data-science.htmlBIBig DataData ScienceDatabasefeaturedPythonRWindowsnoreply@blogger.com (Lilantha Lakmal)Tue, 16 Jan 2018 11:48:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-1845509131062382096 As the world entered the era of big data, the need for its storage also grew. It was the main challenge and concern for the enterprise industries until 2010. The main focus was on building framework and solutions to store data. Now when Hadoop and other frameworks have successfully solved the problem of storage, the focus has shifted to the processing of this data. Data Science is the secret 0http://datatutors.blogspot.com/2017/12/install-and-configure-obiee-12c.htmlBIfeaturedInstallOBIEEWindowsnoreply@blogger.com (Lilantha Lakmal)Tue, 26 Dec 2017 15:32:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-2480724894383909877 Introduction Oracle Business Intelligence 12c is a unique platform that enables customers to uncover new insights and make faster, more informed business decisions by offering agile visual analytics and self-service discovery together with best-in-class enterprise analytics.  Instant mobile, highly interactive dashboards, powerful operational reporting, just-in-time alerts, content and 0http://datatutors.blogspot.com/2017/09/install-and-configure-oracle-data.htmlETLfeaturedInstallODIWindowsnoreply@blogger.com (Lilantha Lakmal)Wed, 20 Sep 2017 22:59:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-6997742303636336539 Introduction Oracle data integrator is a next-generation ETL tool in the market.  A widely used data integration software product, Oracle Data Integrator provides a new declarative design approach to defining data transformation and integration processes, resulting in faster and simpler development and maintenance. Based on a unique E-LT architecture (Extract - Load Transform), Oracle 0Colombo, Sri Lanka6.9270786 79.8612430000000596.8009751 79.69988150000006 7.0531821 80.022604500000057http://datatutors.blogspot.com/2016/08/oracle-repository-creation-utility-for.htmlConfigurationsELTETLfeaturedODIWindowsnoreply@blogger.com (Lilantha Lakmal)Wed, 12 Jul 2017 14:18:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-3049227412512104507 Introduction What is the oracle Repository Creation Utility. ? Many of the Oracle Fusion Middleware components require the existence of schemas in a database prior to installation. These schemas are created and loaded into your database using the Repository Creation Utility (RCU). If you want more details about read below oracle document. https://docs.oracle.com/middleware/1212/core/RCUUG/0http://datatutors.blogspot.com/2016/07/install-oracle-data-intergrator-12c-on_29.htmlELTETLfeaturedInstallODIWindowsnoreply@blogger.com (Lilantha Lakmal)Thu, 15 Jun 2017 15:23:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-7920116570834316550 Introduction Oracle data intergrator is a next generation ETL tools in the market.  A widely used data integration software product, Oracle Data Integrator provides a new declarative design approach to defining data transformation and integration processes, resulting in faster and simpler development and maintenance. Based on a unique E-LT architecture (Extract - Load Transform), Oracle0http://datatutors.blogspot.com/2016/05/pentaho-flat-file-to-table.htmlConfigurationsETLfeaturedPentahonoreply@blogger.com (Lilantha Lakmal)Wed, 3 May 2017 14:55:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-5854192926635128389 Introduction. Hi everyone, In this section I will discuss with you that how to load flat files into the table using Pentaho. Create Transformation 1. Follow the below steps to start the new transformation. File –> New –> Transformation. 2. This is a new transformation window 3. Drag  ‘Text file input’ step under the input folder in design tab and drop it into transformation0http://datatutors.blogspot.com/2016/05/install-and-configure-pentaho-data.htmlETLfeaturedInstallPentahoWindowsnoreply@blogger.com (Lilantha Lakmal)Tue, 11 Apr 2017 12:10:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-6624954273565789488 Introduction Pentaho is an open source business intelligence suite owned by Hitachi data system. They provide the wild range of products. Big Data Solutions . Data Integration (ETL) . OLAP Services . Reporting tools . Dashboarding . Data mining. In this point, I will discuss with you about Pentaho Data Integrator and later I will start a discussion about other tools. There is two main 0http://datatutors.blogspot.com/2016/05/install-and-configure-mongochef-for.htmlBig DataInstallMongoDBStudio 3TToolsnoreply@blogger.com (Lilantha Lakmal)Thu, 23 Mar 2017 11:20:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-5377389549222354528 Introduction. Studio 3T formally call as a MongoChef is a most favourite and easy to use GUI client for MongoDB. If you already not install MongoDB then read the below articles. Install MongoDB. MongoDB GUI Tools. In this section, I will discuss that how to install Studio 3T and connect with MongoDB to run queries. Download & install. 1) Download mongochef from 3t.io 0http://datatutors.blogspot.com/2016/05/mongodb-gui-tools-for-windows.htmlBig DatafeaturedMongoDBToolsWindowsnoreply@blogger.com (Lilantha Lakmal)Wed, 15 Feb 2017 12:49:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-423625726649567464 Introduction. Hi Everyone, My last post I was discussed with you about how to install MongoDB on windows platform, In this session I will  discuss with you about GUI Tools to work and data manipulate with MongoDB.MongoDB does not include a GUI tools.Instead, the most administration is done from command line tool called mongo shell. Anyway, Now a day available some open source and 0http://datatutors.blogspot.com/2016/04/install-mongodb.htmlBig DatafeaturedInstallMongoDBWindowsnoreply@blogger.com (Lilantha Lakmal)Fri, 13 Jan 2017 10:18:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-2485803935478652388 Introduction MongoDB is an open-source document database that provides high performance, high availability, and automatic scaling. It's described as a leading NoSQL Database. MongoDB has been used in the beloved MEAN stack. The benefits of using a document database like MongoDB means that you can work with JSON-style documents across your entire development stack. About Documents Management 0http://datatutors.blogspot.com/2016/04/install-miscrosoft-sql-server-2012.htmlDatabasefeaturedInstallMS SQLWindowsnoreply@blogger.com (Lilantha Lakmal)Wed, 14 Dec 2016 10:47:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-7928495414213888287 Introduction Microsoft SQL Server is a relational database management system developed by Microsoft. In this section, I will discuss how to install and configure Microsoft SQL Server 2012 on Windows Platform. (I am using Windows 7-64bit for in this tutorial) Software and hardware requirements 1) Software requirements .NET 3.5 SP1 is a requirement for SQL Server 2012 when you select0http://datatutors.blogspot.com/2016/04/install-oracle-12c.htmlDatabasefeaturedInstallOracleWindowsnoreply@blogger.com (Lilantha Lakmal)Tue, 22 Nov 2016 15:04:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-4110609115536881589 Oracle is a most favourite and secure database system in the world and also oracle is a DB market leader, In this section I will discuss with you how to install Oracle 12c on windows environment, In this section use windows 7 – 64bit. Download Oracle 12c 1) Oracle 12c Download link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html0http://datatutors.blogspot.com/2016/04/install-mysql-database.htmlDatabasefeaturedInstallMySQLWindowsnoreply@blogger.com (Lilantha Lakmal)Mon, 26 Sep 2016 11:25:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-2151295094418149280 In this tutorial, I will show you step by step how to install MySQL database on windows environment using the mysql installer. After this tutorial, you will have a MySql Server and its tools to running MySQL queries. Download MySql Installer. You can install all components one by one or all in one using installer tool,  Using installer tool is an easy way to install MySQL server on 0http://datatutors.blogspot.com/2016/04/install-oracle-java.htmlfeaturedInstallJavaToolsWindowsnoreply@blogger.com (Lilantha Lakmal)Thu, 25 Aug 2016 13:42:00 +0300tag:blogger.com,1999:blog-7259824531409910228.post-5748048147547452619 Hi everyone, I am Lilantha from Sri Lanka, This is my first blog post, So I will try to build the best blog for everyone working with data, So In this first section I will discuss with you that how to install oracle java on windows environment. Because when we working with data, our fist steps is install java, As per my knowledge many tools related to data management are required java and also 0