Hello, I am currently working on an academic warehouse project using Infoshpere Warehouse. The data source is a remote MySQL database. All went well while within the Design Studio.
I am now trying to deploy the application, but in the Administration Console there is no option to add an external database.
From what I could tell, it seems I need to create a Catalog entry for the remote database. I have tried this approach, but am unable to connect to the database.
Further investigation indicates that I should create a Federated Database to connect to the remote MySQL database. I have done so, and the federated server appears in the Design Studio, but it has no attributes. When trying to create Nicknames for the source tables I get an error: The SQL statement or command failed because of a database system error. (Reason "Can not get server attribute".) SQLSTATE=58004
Am I pursuing the correct approach? What am I doing wrong? What do I need to do?