I'm trying to see if it's possible to set up a project in Alfresco that will provide a basic UI for Database manipulation. Searches for 'database interface management' tell me the words are too common in the alfresco forums, and the only real search result I get is for one of the partners 'Ingres', but that might be far to advanced for the simple needs I have.
Has anyone tried this, or knows of a simple way to access a mysql database on localhost from within alfresco?
Sure, you can add new UI pages to Alfresco that could connect to the DB and manage it, but without knowing your specific use case, I don't really see why you'd want to do that.
Alfresco manages content, and there are plenty of good DB management tools, as I am sure you know.
For accessing MySQL database, I use MySQL tools, which allows me to view and manage it.
The specific use case isn't really specific. And it's not that I want to add UI pages TO alfresco… I want to use the alfresco UI itself. You can add pages in 'web projects', but is there such thing as a 'database' project? Basically 'mysql tools' within the Alfresco UI.
Mostly, I want to go easy on our users and only give them one login/password. They can log into Alfresco and access their data OR their web pages and documents.