TOPIC: Multiple Datasources

Multiple Datasources 28 Sep 2012 11:10 #1179

  • Brockloch
  • Brockloch's Avatar
  • Offline
Hi

I have a large number of reports that get data from 2 data sources. One I connect using udl files and the other odbc. Can logicity handle this?

Ed
The administrator has disabled public write access.

Multiple Datasources 28 Sep 2012 13:00 #1180

  • aellis
  • aellis's Avatar
  • Offline
Ed,

Unfortunately, not currently. We have determined this is going to take a re-write to implement but it is definitely on our list as a highly important feature. In the meantime, the only real workarounds known are:

- Implement a type of database authentication that doesn't require credentials to be typed in (i.e. Active Directory authentication).
- You can use File DSNs instead of System / User DSNs and store the password within the .dsn file itself.
- Implement database views that cross over multiple databases so that your reports only need to point to one "database" - the one that contains the views.

Nothing ideal but that is where we stand currently.

-Adam
The administrator has disabled public write access.