CRM SP calling BBDW functions

Rob Mendes

I built a report that uses objects on both the TPS and the BBDW. 

In the dev environment the DB’s are all on the same machine so it works fine; but in prod the TPS and BBDW are separate machines and as a result CRM can't find the BBDW functions

Other than a DBlink is there any BB object that we can leverage to handle this?  Specifically, a Proc on the TPS calling functions on BBDW and TPS.


Thanks,

Rob

 

Rick Root

We actually have our BBDW on the same server as our transactional DB, though we used to have them separate.


I recommend against using any kind of DB Linking.  HORRID performance.


The only thing you could do would be to build a custom SSIS package to copy tables you want to access in the transactional database back from the BBDW.  That's what we used to do when we wanted to expose BBDW tables in combination with transactional data.

Joseph Styons

Hi Rob!

If it wasn't a report, I'd say the best way I know to deal with this is to:

1) Create a custom datalist or view form.

2) Specify the MartKey="<your martkey>" tag

3) Call the datalist or view form as an endpoint from code


But since this is a report, I think your best bet is just to add the needed data to the BBDW.

J.R Styons

https://www.styonssoftware.com

Rob Mendes

Thanks. Looks like using a ETL to copy the data over the the BBDW, is the best option. Thanks guys for the great advice.