Openfire Database Export

I am attempting to export the tables and data from the embedded-db in openfire. First, I’ve tried to use the db viewer that i’ve heard of, but either can’t find it or its not installed. Second, i’m trying to export chat converstation from the database. If i can at least get the database viewer running, i might be able to create a script to extract data from the database. any and all advice is welcome. thanks in advance.