NicT
20-Jun-2013, 07:48 PM
Hi all,
We are in the process of rolling out a pre-defined set of read-only reports using Dynamic AI to some of our existing Autosoft (VDF app, SQL Server db) customers. Bob Cergol has been very helpful with this so far. I wanted to swap our discussion over into the forum area so that more people can A) share in the discoveries and B) help guide the discussion. I have two problems - 1 right now and another likely in the near future.
Problem number 1: Distribution of DAI to each new customer site requires modification of the SQL Server instance name and DB name after DAI is installed.
At the moment, we are doing this manually, and that is OK at the moment, but it would be nicer to have this be able to be done programmatically. Bob has sent me a separate email describing an interface to the DAI repository from VDF which can modify the instance and db names, though I haven't tested this out yet. That's all well and good, except for problem number 2.
Problem number 2: Ability to run the same set of reports on different databases on the one client site, ie. different DBs on the one SqlSvr instance.
What I have read so far, including Bob's process, seems to say that a report uses one connection, and one connection has one "value" (ie. points to a single datasource) at a time in the DAI server. And THIS implies that we can NOT have two different users on the one server looking at the same set of reports but pointing to different databases at the one time. This is a problem because some of our customers will not use DAI unless we can allow this to happen.
My question:
-- Is my conclusion for Problem 2 correct?
-- If so, is there any way around this?
-- If not, how does this work?
-- Is it possible to change the DB connection used by a report at runtime?
Thanks in anticipation,
Nic Townsend
Autosoft, Sydney
We are in the process of rolling out a pre-defined set of read-only reports using Dynamic AI to some of our existing Autosoft (VDF app, SQL Server db) customers. Bob Cergol has been very helpful with this so far. I wanted to swap our discussion over into the forum area so that more people can A) share in the discoveries and B) help guide the discussion. I have two problems - 1 right now and another likely in the near future.
Problem number 1: Distribution of DAI to each new customer site requires modification of the SQL Server instance name and DB name after DAI is installed.
At the moment, we are doing this manually, and that is OK at the moment, but it would be nicer to have this be able to be done programmatically. Bob has sent me a separate email describing an interface to the DAI repository from VDF which can modify the instance and db names, though I haven't tested this out yet. That's all well and good, except for problem number 2.
Problem number 2: Ability to run the same set of reports on different databases on the one client site, ie. different DBs on the one SqlSvr instance.
What I have read so far, including Bob's process, seems to say that a report uses one connection, and one connection has one "value" (ie. points to a single datasource) at a time in the DAI server. And THIS implies that we can NOT have two different users on the one server looking at the same set of reports but pointing to different databases at the one time. This is a problem because some of our customers will not use DAI unless we can allow this to happen.
My question:
-- Is my conclusion for Problem 2 correct?
-- If so, is there any way around this?
-- If not, how does this work?
-- Is it possible to change the DB connection used by a report at runtime?
Thanks in anticipation,
Nic Townsend
Autosoft, Sydney