Trying to use BVM

[Seabz420]

I'm trying to the BVM to create a data connection to our SQL server. I want this so when someone creates a report, they don't have to set it up on their computer, then can just pick the connection from the repository. I'm just not sure what I need to do. I've created the connection, but when I go into CR 10 and try to pick the connection from the repository, all I see are the folders I've setup and nothing else. Am I missing something? Do I need to setup something else before I can use the connection?

 

[bdreed35]

Take a look at the BV tutorial in the BVM help.

After you create the Data Connection, you have to create a Data Foundation.
After the Data Foundation, you create a Business Element, then a Business View.
The Business Views are what you would use as a datasource for your report.

~Brian

 

[Seabz420]

So basically I have to setup the table structures for a particular report in order to create a data connection to it? I have 77 tables in this Database. None of the tables are linked together. When the reports are created, that is when the linking happens. Is there no way to create a connection to the database and save that in the BVM? We have too numerous of reports to create a any sort of generic connection. I'd like the connection setup to just point to the DB (like any local ODBC connection would do). Then when create a CR, the user can grab the ODBC connection from the the repository and then select the tables to use from there. Is this possible or just a pipe dream?

 

[dialworld]

Actually, any connection you create in BVM (say an ODBC), has to be setup on the user's PC anyway. The only advantage of BVM at the connection level is that you can have a parameteer that asks which connection to use (say between dev and prod, or as we use here, the Western, Central and Eastern region databases), all connection drivers and configuration still need to be on a PC if used through CR designer.

I have a feeling that what you want is what they're aiming at in the lon-run but right now I don't think BVM will help you the way you want...