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|
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.
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 »
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.
IMPLEMENTATION OF NUMBERFORMAT GROOVY SCRIPT: Read the rest of this post »
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 »
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 »
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:
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.
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 »
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.
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 »
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 »