How to edit connection on existing dashboard or visualization

Scenario: You have built a dashboard on a development database connection and you need to migrate to a production server using production database. How do you change the connection on the dashboard charts and visualization? There are two ways to … Continue reading ?

By: InfoCaptor Dashboard

How to delete or disable JDBC or database connection

Here are the steps to disable or remove any connection handle From the launch pad, click on Manage project/Users Switch to the “Database” Tab Select the connection handle by clicking on it Next, click on the pencil icon to edit … Continue reading ?

Source: InfoCaptor Dashboard

Firebird JDBC example and SQL to build dashboard

Here are the detailed steps to get connected with Firebird using JDBC and build dashboard with InfoCaptor. Assumptions Make sure Firebird is installed Make sure Firebird server is running Setup SYSDBA user and password (the default password is masterkey) 1. … Continue reading ?

Source: InfoCaptor Dashboard

Top 12 Rank Tracking Software and services for your business needs

The role of Search Engine Optimization and keyword tracking tools are important in this technological age. This is especially true for people involved in business. One sure way to track the performance of a business is to use software specifically … Continue reading ?

By: InfoCaptor Dashboard

How to Attract Visitors to Your Site?

It’s not that easy to go from zero visitors to thousands of potential customers in an instant. But if you implement the right traffic-generating strategy, you can increase the number of visitors coming in to your website. If you can … Continue reading ?

Via: InfoCaptor Dashboard

What Are the Steps to Optimizing Your Website

People use search engines like Google when looking for products or brands these days. In fact, 60 percent of consumers take advantage of Google search just to find what they exactly want, and more than 80 percent of online search … Continue reading ?

Credit: InfoCaptor Dashboard

Best Tools for Keyword Rank Tracking

An important element of search engine optimization (SEO) is choosing the right keyword. With the right keywords, you can make your content rank on search engines. But the work doesn’t stop after ranking, you still need to track the position … Continue reading ?

Hat Tip To: InfoCaptor Dashboard

Sneak Preview of pgio (The SLOB Method for PostgresSQL) Part I: The Beta pgio README File.

The pgio kit is the only authorized port of the SLOB Method for PostgreSQL. I’ve been handing out Beta kits to some folks already but I thought I’d get some blogs posts underway in anticipation of users’ interest.

The following is part of the README.txt for pgio v0.9 (Beta). SLOB users will find it all easy to understand. This is the section of the README that discusses pgio.conf parameters:

UPDATE_PCT
The percentage  (more...)

Running Code as SYS From Another User not SYSDBA

I have been embroiled in a twitter thread today about the post i made in this blog yesterday around granting privileges to a user and who should do the granting. Patrick today asked a further question: How do you make....[Read More]

Posted by Pete On 22/05/18 At 08:42 PM

Docker: Lessons learned – Logging

After some time working with docker here my experiences:

Some days ago i created my own container with a minimal web service.

Here the ncweb.sh:
#!/bin/ash
sed -i  's/Hostname:.*/Hostname: '$HOSTNAME'/g' index.html
while true; do { echo -e 'HTTP/1.1 200 OK\r\n'; cat index.html;}  | nc  -l -p 8080  2>&1 >> logfile; done
This is the Dockerfile:
FROM alpine

WORKDIR /tmp

RUN mkdir ncweb

ADD .  /tmp

ENTRYPOINT [ "/tmp/ncweb.sh" (more...)

Simple CQRS – Tweets to Apache Kafka to Elastic Search Index using a little Node code

Put simply – CQRS (Command Query Responsibility Segregation) is an architecture pattern that recognizes the fact that it may be wise to separate the database that processes data manipulations from the engines that handle queries. When data retrieval requires special formats, scale, availability, TCO, location, search options and response times, it is worth considering introducing additional databases to handle those specific needs. These databases can provide data in a way that caters for the special (more...)

Enabling Excel Functions in BI Publisher Report Excel Output

When displaying numerical data in BI Publisher report using the Excel format, leading zeros in the output values is removed automatically by MS Excel. One way of preventing this is to use fo:bidi-override.

BIP_Excel

This, however, leads to the situation where Excel functions such as SUM, AVERAGE etc do not work on the values which are displayed using the fo:bidi-override option. This is because of the special characters which are automatically added before and after the (more...)

Export – Import Business, Again


"At first it was difficult to tell just what had changed—it all looked the same
and it all smelled the same—but, for some reason, nothing sounded the same."
-- Norton Juster, The Phantom Tollbooth

Doing things just because “they’ve always been done that way” may not be the best reason to stick with old and accepted processes and utilities. Oracle has changed significantly over the years and those improvements shouldn’t be ignored simply because (more...)

Who Should Grant Object Rights?

Patrick Jolliffe posted a question via a tweet back in April but due to personal health pressures with a close relative of mine I have not had the time to deal with much over the last few months. I did....[Read More]

Posted by Pete On 21/05/18 At 07:08 PM

EBR – Part 7: Editioning Views

This is part 7 of a post series about EBR.

Visit the index page for all the parts of the series

Introduction

Our next use case is adding a column that represents a new logic to the PEOPLE table, and making the corresponding changes in the PEOPLE_DL and APP_MGR packages. Of course, as we speak about EBR, the upgrade from the previous version to the new one should be online.
An online upgrade means that (more...)

5 years

I’ve joined Pythian exactly 5 years ago. Back then I was a performance guy, with no real DBA and operational support experience. I knew enough about technologies though. Still getting up to speed with common admin tasks took me almost a year. At some point later it became a bit boring: dealing with out of space issues and other noise during on-call can’t be appealing for long. After ~2 years I had an opportunity to (more...)

Rapidly spinning up a VM with Ubuntu and Docker–on my Windows machine using Vagrant and VirtualBox

imageI have a Windows laptop. And of course I want to work with Docker containers. Using the Docker Quickstart Terminal is one way of doing so, and to some extent that works fine. But whenever I want to have more control over the Linux environment that runs the Docker host, or I want to run multiple such envionments in parallel, I like to just run VMs under my own control and use them to run (more...)

Creating a Word Cloud using Python

Over the past few days I've been doing a bit more playing around with Python, and create a word cloud. Yes there are lots of examples out there that show this, but none of them worked for me. This could be due to those examples using the older version of Python, libraries/packages no long exist, etc. There are lots of possible reasons. So I have to piece it together and the code given below is (more...)

Advanced Compression no good for Data Warehousing

This post is about experiencing "table fetch continued row" in compressed data warehouse tables that experience some level of updates to existing (old) data, and how using the Advanced Compression option of Oracle Enterprise Edition not only does not help in avoiding this but can actually introduce severe performance penalties into your daily load jobs.

Background

Basic Compression is a free part of Oracle Enterprise Edition, allowing you to compress the data within (more...)

R13 – Get Username Displayed Again

One of the things that we lost when we moved from R12 to R13 is the username in the top right corner. For end-users in production it doesn’t really matter as they’ll only be logging in as themselves, however during the implementation in Test we frequently log-in as different personas so it’s useful to see who the user is for your current session.

username

The initials we have in R13 offer a clue, but in non-Production (more...)