Its the data gods that say, “Go Forth and Pivot”.  The Nexus has 1,000 features on 1,000 different database platforms, and feature number 942 is pivoting.  Business users and senior management love to see a pivot report, especially when it has sum totals, subtotals, and horizontal and vertical grand totals. 

Read More

We are proud to offer Universal ODBC – our new connection method that allows users to connect to and interact with any current or future ODBC data source in the universe.  

Nexus has always been able to interact with over 25 major data sources natively, but not brand-new data sources.  With Universal ODBC, users can now connect to any data source, display the database layout in our Unified Systems Tree, execute SQL, and interact with result sets in exactly the same way they can from any of our native connection methods.  All that is needed is an ODBC driver.

There are so many new and exciting databases emerging daily, but until now, users have had limits to using the simple vendor-supplied “afterthought” query tools designed specifically for those systems. Nexus Universal ODBC allows users to query new cloud or on-premises databases on the day they’re released.

Read More

I can teach you analytics!  I have never seen a database do analytics better than Snowflake.  This week we are working on the RANK command. In each example, you will see an ORDER BY statement, but it will not come at the end of the query.  The ORDER BY keywords is always within the RANK…

Read More

Moving data between systems is called ETL, which stands for Extract, Transform, and Load.  The ETL team almost always does the moving of data because load scripts are easier to learn than Latin, transformation is more difficult than brain surgery, and computing resources are about as easy to manage as cats.

Read More

  I can teach you analytics!  I have never seen a database do analytics better than Snowflake.  These analytic lessons are the perfect opportunity for you to learn analytics like the back of your hand.  If you want your career stock to soar, then invest in yourself and learn these analytic lessons.  You are about…

Read More

  Yesterday – My Netezza troubles seemed so far away. Since IBM bought them now, they’re here to stay. Oh, I believe in yesterday. Suddenly, I’m not half the man I used to be. Why can’t I migrate off so easily? Oh, I believe in yesterday. Why it had to go, I don’t know, they…

Read More

If you could go back in time and you wanted to see Einstein cry, ask him to come up with a “Theory of Data Movement”, instead of a “Theory of Relativity.” Moving data between different vendor database platforms is close to impossible.

Read More

Tom has broken the search record on O’Reilly Media when it comes to Data Engineering. Tom Coffing has been in the data warehousing game for more than thirty years – and his books can be found on the shelves of some of the best data scientists out there.

Read More

Let’s take what we learned about Reading and Writing files in Python and see what happens when you utilize this function with an SQL system. Then we can explore more advanced variations of Reading and Writing in Python.

Read More