My company decided to use the Fishbowl Point-of-sale system to handle bookstore activities. My project was to get transactions out of this system and imported into our SMS (Student Managment System) for which we use CampusVue.
Fishbowl's back-end is an open-source DBMS called Firebird. CampusVue is running on a SQL Server database.
As usual I decided to use SSIS to achieve this task.
The first challenge was to be able to connect to the bookstore database. Upon reviewing documentation of the Fishbowl product I was able to create an ODBC connection to it. You will need to obtain the credentials used if you are facing the same task. This particular credentials only allows reading of the data but that's all I need.
Here is the way the ODBC connection is set up for all who needs it.