Databases Download and Install SQLite Studio By Ramu Vudugula Download and Install SQLite, Installing sample database and connecting to a database using SQLite Studio Summary: This tutorial shows step by step how to download and install SQLite, installing sample database in the SQLite and connecting SQLite database using SQLite...
Databases Solution for “Server Not Listening” Error in Postgres Server By admin In this blog the following topic will be covered How to resolve “server not listening error” in Postgres server while connecting from another host Prerequisites: PostgreSQL-9.3.4-1 Install Postgres in the local machine. If other hosts want to connect to the...
Databases Convert the MongoDB Object Id to String in Drill By admin Mongo Database is document-oriented database. Unlike the relational database, In the Mongo database, data will be stored in JSON-like documents. MongoDB stores data in flexible, JSON-like documents, meaning fields can vary from document to document and data structure can be...
Databases Overlaps in PostgreSQL By Sohail Usually, we get to pass a date between two different dates eg. To find Employees Active in a company we can say current_date between the effectivedate and end date, this will return effectivedates that match the above condition. But what...
Databases Encrypted Token Generation From Given Input Data Using Java By admin For data confidentiality and Data security purpose we can use the data in many places by encrypting it. Hereby using a java code we can get the encrypted data. For Example, if we want to request a server to log...
Databases How to Write SQL Query in Parameter and Use it in Main and Sub Datasets By Satya Gopi Prerequisites: Jasper Server 6.4.2 Database: Foodmart In this blog, we will learn how we can write an SQL query in parameter and use in Main Dataset or Sub Datasets. Created a sample query which as follows and created a report...
Databases Comparison Between PostgreSQL and MySQL By admin Key Differences Between PostgreSQL and MySQL Database Ever asked a question: Which database you will prefer? Postgres over MySQL and MySQL over Postgres. I would say the answer would depend upon your preferences. Both the database has there pros and...
Business Intelligence Metadata Injection in Pentaho Data Integration By Sohail Metadata Injection in Pentaho Data Integration The ETL Metadata Injection step inserts metadata into a template transformation. To Explain further, Let's have a simple scenario of Loading CSV Data into a Table, Make data easy with Helical Insight. Helical Insight...
Business Intelligence How To Install NTP Client On Ubuntu 16.04 By Sayali Mahale How to install NTP Client on Ubuntu 16.04 Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail Version To install NTP Client on Ubuntu 16.04 follow below...
Databases Recursive With Query in Postgres By shailaja Recursive WITH Queries in Postgres Sometimes we might have a requirement for certain hierarchy relation in data. This can be done with the help of Recursive WITH Queries(Recursive CTE) in Postgres. Consider the example - Location is stored in table...
Big Data Get Historical Twitter Data Using Twitter4j Libraries In Java By admin Get historical Twitter data using Twitter4j libraries in java Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail Version Pre-requistes : 1. Valid twitter account 2. Some...
Databases Cassandra Installation and Cluster Setup on Ubuntu By admin Cassandra Installation and Cluster Setup Cassandra Introduction This blog covers Cassandra installation. Apache Cassandra is a free and open-source distributed NoSQL database management system. It is designed to handle large amounts of data across many commodity servers, providing high availability with no...