Monthly Archives: August 2008

Increase Productivity!!

We design and build solutions that increase productivity in your business!

What kind of productivity?

Business productivity!

I guess you do it all. I’d like that.

More productivity?

I want more profit.

We can help with that!

You can? Why don’t you just say, “We make you more money.”

We improve the productivity of your business!

That’s not the same thing at all. “Productivity” is vague and unmeasurable.

We can help!

Can you help me make more money?

We can help you become more nimble!

What does that even mean? Can anyone measure it?

We help you compete in a global marketplace!

I’m a lot more concerned about the competition knocking on my customer’s door today.

We can help you manage your customer relationships!

Will that make me more money?

It helps productivity!

So you want to sell me services to improve my productivity, but they might not make any money?

We can do whatever you want us to do!

Your website says you have the “skills and depth of experience” to help my business be more productive.

You want to be more productive?

I’d like to make more money.

We can help!

Improving The Load Process With Multiple ODBC Connections

One of the most useful tricks shared at the QlikView conference was from Nik Boman on improving the data extraction from databases.

ODBC is a slow protocol, running orders of magnitude slower than the database or a typical Ethernet connection. Very pricey ETL tools for data warehousing get around this by extracting through multiple connections to the database, and there’s no reason that a QlikView infrastructure can’t take advantage of it.

For example, run two copies of QlikView at the same time and extract approximately half of the data set with each. First, make a copy of the QV.exe file and give it a unique name. You can open QV.exe and your unique copy at the same time. You can run three or more copies of QlikView with this method.

Next, decide how to divide your data set; it could be based on date, country, state, or half the alphabet, for example. What you want is to divide the data set into roughly equal segments, one for each copy of QlikView.

How does each copy of QlikView know which segment to load? One way to do this dynamically is to use the command-line to set a variable in the script. Reference this variable in the SQL SELECT statement in the script: WHERE YearField=$(vYearVariable). See the reference manual for command-line options.

Your mileage will vary. Some databases don’t do much better with simultaneous ODBC reads. Oracle does quite well.