cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1709
Views
0
Helpful
3
Replies

Multiple Data Sources for CUIC Report Definition

muratbek
Level 1
Level 1

Hi All,

Is it possible to create a custom Report Definition with multiple data sources? I would like to create a report that uses data from UCCE Historical DB and CVP Reporting DB. So far it seems that a Report Definition can query only a single data source. How can I solve this?

Any advice is appreciated.

CCE 11.5

CVP 11.6

CUIC 11.5

Thanks

1 Accepted Solution

Accepted Solutions

You can't, unless you were to offload all of your data into some data warehouse where you can manipulate/query it as needed. It is a limitation of CUIC.

 

View solution in original post

3 Replies 3

You can't, unless you were to offload all of your data into some data warehouse where you can manipulate/query it as needed. It is a limitation of CUIC.

 

Thank you very much. That's what I was afraid of (((

have a look at linked servers ... this will allow you to query multiple DBs from one data source.

 

https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-2017