How to Connect Hortonworks Hive from Qlikview with ODBC driver

As with most BI tools, QlikView can use Apache Hive (via ODBC connection) as the SQL access to data in Hadoop. Here we are going to talk about qlikview how to connect Hortonworks Hive via ODBC.


1.Those are versions of each component we installed in Hortonworks

Hue HDP Hadoop Hive-Hcatalog Ambari HBase Hortonworks ODBC Driver
2.3.1 2.1.2 2.4.0 0.13.0 1.5.1 0.98.0

Read the rest of this post »

How to Implement JMSProducer and JMSConsumer

In this blog post, I have captured the process to implement a JMSProducer and consumer example.

The primary objective is to build an OSB project, which will perform the following functions:

Creating JMS Server, Queues and Topics:

To create a business and proxy service, we have to start with creating a JMS Server, queues and topics.

  1. Creating JMS Server
  2. Creating JMS Module
  3. Creating Queue
  4. Creating Topic

Creating JMS Server:

Step 1: Go to the WebLogic server->Under Domain structure Section, Click on services>Messaging>JMS servers. On JMS servers Page, click on “New” button.

On the create a New JMS server page, provide a name for the server


Step 2: After creating the JMS Server, we need to select the Target server instance where we have to deploy our JMS server

Select the Target server from the dropdown list and click ‘Finish’ to complete the JMS server. Read the rest of this post »

Posted in News

How to Format Currency with Globally Defined Groovy Script

In several OSC (Oracle Sales Cloud) based application, there comes a requirement where a currency value needs to be formatted according to the currency format of the locale. In general Groovy compiler supports NumberFormat abstract class which can be called as NumberFormat.getCurrencyInstance() which returns the formatted object. This simple method-call will convert the given number to the required currency format. But OSC compiler for groovy does not support the method call to the aforementioned abstract class.

We came across a similar situation, where we had to format one of the fields to US currency format and the formatted value needs to be passed in the email template. To achieve this we implemented a groovy script that converts the given number to string, parses it and converts to the desired format by calculating the length of the given value.


3 Ways to Load Data From HDFS to HBase

Apache HBase™ is the Hadoop database, a distributed, scalable, big data store. If you are importing into a new table, you can bypass the HBase API and write your content directly to the filesystem, formatted into HBase data files (HFiles). Your import will run much faster.

There are some ways to load data from HDFS to HBase. I practiced loading data from HDFS to HBase and listed my process step-by-step below. Read the rest of this post »

Posted in Big data

Utilizing AngularJS and LESS in AEM context

In the project which was ended long before, worked as a front-end developer, I faced the challenge that I needed to develop a suitable workflow for front-end development in AEM context. Besides the three well-known mundane front-end technologies – HTML, CSS and JavaScript, I managed to get another two good helpers – AngularJS and LESS, which were really great tools and contributed a lot to the final success of the project.


What is it?

Read the rest of this post »

Posted in Coding, Web application

SparkR for Data Scientists

Although the title Data Scientist is not mentioned as often as other IT job titles, it has been in the IT world for a while and is becoming more important with the popularity of the Internet and eCommerce. What kind of skills should a data scientist have? It could be a long list, but I think a data scientist at least needs to be good at: Read the rest of this post »

Comparison of Test Management Tools

Test management is the activity of managing a software testing process. It’s an important phase to focus on in order to get high-quality software. Examples include creating and executing test cases. To manage these activities, we use test management tools. There are currently lots of user-friendly test management tools available on the market. Some are open source and some are licensed.

Why Test Management Tools:

  • A test management tool acts as a common place where all the test cases required for execution are stored so updates to the test cases reach all members involved in it
  • Repetition of work can be avoided
  • Increased productivity in a short duration

The test management tools used for comparison are PractiTest, Qmeter, TestRail, Zephyr, qTest, TestLodge, Testuff, Testcollab, Gemini, and TestLink. All of these tools have their own pros and cons. The tool comparison matrix below will help in selecting the best test management tool based on the requirements.



Posted in News

DevOps, Agile and Mobile Developing

Unlike most traditional program products or IT solutions, mobile development is very dynamic. You must follow the evolutionary change of mobile devices regularly to keep up. Usually, faster response, adaptive planning, early delivery and flexible response to change are the keys to providing a successful mobile app solution. An agile software development style, such as SCRUM, or a faster Iterative and Incremental development is highly recommended to be embedded in mobile developing.

In our China office, we use SCRUM development in most of our focus areas and mobile development equally. We work in sprints and deliver continuously. The lifecycle looks something like this: Read the rest of this post »

Get HTTP Cookie for Web Service Authorization in SoapUI

Web service may need credentials to allow a client to make a request call to the report server. The authorization method depends on the security settings for your report server. SoapUI is a popular web service testing tool, and testers need to send authentication information in SoapUI to the server before testing target requests.

Authorization Types

SoapUI provides a UI function to get credentials for basic authorization, NTLM authorization, and OAuth 2.0 authorization. Testers just need to select the authorization type and type username, password and domain, then the request can pass the authorized information to server. But some servers need to get the sessionID or cookies to validate instead of username. In this blog post, we will discuss how to get the HTTP cookie as a credential. Read the rest of this post »

Posted in Testing

Exchange Data between TM1 Instances by TM1RunTI

Here is an example to transfer data between TM1 Instances byTM1RunTI configuration file and some tips for trouble shooting.

TM1RunTI is a command line interface tool that can initiate a TM1 TurboIntegrator (TI) process from within any application capable of issuing operating system commands. That means it can be called cross TM1 Instance, especially when you want to exchange data between instances.

Suppose there are two TM1 Instance A and B. Now we want to transfer data from A to B. The TI in instance B will be called by TI in instance A, so the data can be loaded into instance B. Read the rest of this post »

Posted in BI&Database