Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Is it Possible to Connect Gemini Database to Access

web-app

Hello,

I am just starting at a company that is interested in using Gemini.  It seems like a very nice package.  However, it is lacking the types of reports that I need to present issues to management.  The information  that is exported in excel and the printed reports are not adequate.  So, I would like to us a utility like Crystal Reports or Access to generate the types of reports that I need.  I am not sure if it is possible to connect to the Gemini database for this purpose. 

Can anyone give me some direction.  I would prefer to use Crystal Reports for this.

Thanks
Dzikiewicz
· 1 		Dzikiewicz
Wednesday, June 13, 2007, 5:05:57 PM
Replies (3)
helpful
0
not helpful

Yes, it is possible to use either Access or Crystal Reports. Just set up an ODBC connection to the SQL database.
Saar Cohen
· 5000 		Saar Cohen
Wednesday, June 13, 2007, 5:35:07 PM
helpful
0
not helpful

I guess thats the part I am getting stuck with.  I havent had to do this in quite a while.  I am going into the control panel and doing an add data source and Im not sure of the proper source.  For example, User DSN, File DSN, etc...  Next I do not know the name of the instance of the gemini data base or the schema name.
Dzikiewicz
· 1 		Dzikiewicz
Thursday, June 14, 2007, 3:49:18 AM
helpful
0
not helpful

You need to add a "System" data source using the SQL Server driver. You can find the instance and database via the connection string in your web.config file.
Saar Cohen
· 5000 		Saar Cohen
Thursday, June 14, 2007, 10:07:50 AM