Author Archives: Online Education

ETL comes from Data Warehousing and stands for Extract-Transform-Load. ETL covers a process of how the data are loaded from the source system to the data warehouse. Currently, the ETL encompasses a cleaning step as a separate step. The sequence is then Extract-Clean-Transform-Load. Let us briefly describe each step of the ETL process. Process ExtractContinue reading “ETL (Extract-Transform-Load)”

Integrating cloud platforms with traditional ERP platforms like SAP is difficult, and ERP integration methods like SAP’s Application Link Enabling (ALE) are limited and inflexible. Attempts to improve flexibility have compounded the complexity. For most IT organizations, integrations between systems is a difficult, budget-consuming endeavor. Since large ERP vendors are systems of record, their requirementsContinue reading “Workday Tools for SAP Integration”

When it comes to Business Intelligence tools, Tableau and Microsoft Power BI are the standout performers in the recent decade. Tableau since its inception has come a long way and has established itself as the market leader for BI tools and data analytics. Microsoft Power BI though relatively younger has grown to be the closest competitor for Tableau.Continue reading “Tableau vs Power BI the difference”

What Are the Data Types Supported in Tableau? Following data types are supported in Tableau: Text (string) values Date values Date and time values Numerical values Boolean values (relational only) Geographical values (used with maps) What is Meant by ‘discrete’ and ‘continuous’ in Tableau? Tableau represents data depending on whether the field is discrete (blue)Continue reading “Tableau Interview Questions and Answers”

Hadoop’s significance in data warehousing is progressing rapidly as a transitory platform for extract, transform, and load (ETL) processing. Mention about ETL and eyes glaze over Hadoop as a logical platform for data preparation and transformation as it allows them to manage huge volume, variety and velocity of data flawlessly. Hadoop is extensively talked aboutContinue reading “Reasons Why ETL Professionals Should Learn Hadoop”

First, if you have ever had to integrate using the SOAP protocol, then you already know that it can be cumbersome to use when compared to using lighter frameworks like REST. Workday’s API is SOAP. Thus, as is the case will all of the connectors in the Open Connectors ecosystem, the Workday Connector converts and normalizes Workday’sContinue reading “New Workday Connector Now Available in Open Connectors”

DevOps helps improve collaboration between development and operations. It uses data to automatically create, authorize, and close a change request to go from days to minutes. It provides new insights on developer and operator dashboards to improve collaboration and drive behaviors. Note: The DevOps product is rolling out gradually by region with an initial focus on the NortheastContinue reading “DevOps workflow in Servicenow Orlando version”

The Java platform is a free software download that many of today’s websites and apps can’t run without. Java is practically a requirement for most internal and cloud applications. Developers use its object-oriented programming language to build desktop and mobile apps. You can write complex ETL (extract, transform and load) processes in Java that go beyond what’sContinue reading “ETL Tools That Do More With Java”

Couchbase Server is a hybrid NoSQL database that supports operational and analytical workloads. Couchbase Analytics in Couchbase Server 6.0 brings “NoETL for NoSQL,” enabling users to run ad-hoc analytical queries on JSON data in their natural form — without the need for transformation or schema design — by leveraging a massively parallel processing (MPP) query engine. Every enterprise has already invested inContinue reading “Build a Real-Time Data Visualization Dashboard With Couchbase Analytics and Tableau”

Integrate Microsoft Azure with Event Management. To add the Azure platform as a data source, configuration is required in the Azure platform. Before you begin Role required: evt_mgmt_admin and web_service_admin The Event Management integration with Azure supports the Azure Classic Metric Alert format, also known as Insights Alerts. For this format, Event Management provides a dedicated listener, Azure Events Transform Script.Continue reading “Integrate Azure platform as a data source”