MySQL Enterprise Manager

Now that I have installed MySQL (and finally found out I only installed the server, no client access tools yet), I need some tools to connect, and maintain my database. The first one I am going to check out is the SQLyog MySQL GUI. 

Here is the command to check out if MySQL is installed: ps -A | grep "mysql, the result is 

5002 ?        00:00:00 mysqld_safe
5058 ?        00:00:00 mysqld

 

More OSBI (Open Source BI)

I ran into the interesting blog of Chris Webb who has been working on Microsoft BI as well as on open source. He mentions some other open source tools, besides Pentaho and Jasper he has been working on.

• Olap4j this looks more like a development environmen, but Chris claims it also can connect to Microsoft Analysis Services 2005. And since I am also quite familiar with the Microsoft suite, this can be great.
• Cubulus, check out the demo at http://alxtoth.webfactional.com/, Cubulus is an analytic engine + slice&dice web interface on top of relational database (MySQL at the moment)

 

Hypersonic database

I found out about another opensource db. Yes, I’m kind of new in the open source playing field. Anyone experience with this ? Does it support al the nice things that I know, such as functions, stored procedures ? Actually, the same goes for HsqlDB, I also found out about that just last week. How do these 2 compare to MySQL, as that seems to be the open source database market leader.

Actually, some Google work tells me that HsqlDb is the continuation of Hypersonic.

 

Installing Pentaho on Ubuntu

Pentaho Open BI Suite, Pre-configured Installation (PCI) – MySQL
Ready to serve. Pentaho Open BI Suite is our application already configured and deployed into JBoss. Connected to a solution repository, it is ready for you to store and run your own solutions. To help you get started, it includes a sample solution for demonstration and reference.
Version: 1.6.0.GA.863 (GA)

I’m downloading now. Hopefully it will connect to my ‘hidden’ MySQL installation. Stay tuned.

 

Confused

Yesterday, I installed MySQL through the terminal command. I was surprised to find out that I could not find any presence of MySQL on my Ubuntu machine. So, I ran the installation command again. This gave me the message:

$ sudo apt-get install mysql-server
Reading package lists… Done
Building dependency tree
Reading state information… Done
mysql-server is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

Am I too much in Microsoft mode now ? is there another way to start MySQL, or am I trying to find an Enterprise Manager type of tool that isn’t there. If there is any help for me, please reply to this post.

 

Open Intelligence

Discovered a great blog today, called Open Intelligence. Hosted by Erik Swenson. Erik is the founder of OpenReports and ObjectVisualizer.

 

HSQLDB

Open Office is installed together with Ubuntu. I found out today that I can create databases from within the Open Office toolset. The database used is the HSQLDB: “100 % JAVA Database”. I will give it a go to find out what this offers, but my idea is that I will need MySQL when it get’s nasty (high volume datawarehouses).

 

Arrah

After finding out about Apatar, now I run into Arrah. “The world’s first open source data profiler and data quality tool”. Let’s check it out !

 

Going Ubuntu

At the moment I am configuring an old desktop, to become my open source system. Ubunty 7.10 (Gutsy Gibbon) is already installed. So far, I like it. I am used to working with several versions of Windows, it takes only little time to get familiar with the interface. One very interesting thing is the way to install new software. It can be done through the Synaptic Package Manager, a whole library, or you can offcourse find downloads on the www. Right now I am installing MySQL, and I simply took the installation command from the website ( sudo apt-get install mysql-server), and I don’t have to bother about choosing a mirror or location, everything is arranged for me. So, after this, I will install a choice of BI Tools on this machine, and will be building BI solutions.

 

Apatar

Today, I stumbled upon Apatar. They are in beta – connecting data.

"Apatar is the leading provider of open source software tools for the data integration market. Apatar brings data integration to the companies who previously found proprietary solutions expensive and difficult to implement. Apatar’s goal is to provide more than 100,000 users with its freely downloadable product by the end of 2007. Apatar provides support, training, and consulting services for its integration solutions. "

Interesting: Apatar supplies open source software, but since that doesn’t heat up the fire, they are the supplier of support, training and consulting. Very smart.

Anyone has experience with Apatar ? The interface is very much Kettle alike. That makes it look a lot like SQL Server Integration Services as well. Intuitive data flows, bringing data from point a to point b.

I can’t judge on the software yet, but the company has an interesting offering. I think a lot of similar companies will rise over the next period. Embracing open source, not making money on licences, but making money on the services and support side.