Load data from another site while in current site

CSI 9.01.12 on prem, Windows Server 2016, SQL Server 2014

I've gotten several requests from users to make data available on a form in all sites. The problem I'm having is we are multi site, multi database. Data exists in our primary site, but not in the others. When an IDO loads, it is going to load the data from the current site only.

How do I tell CSI to load the data from a specific site? I've been looking at options and have a few thoughts:

Write a CLM so the system performs SQL queries to return the data from the correct site
Use the REST API to 'sign in' to the other site and pull the information from there, then populate the IDO in the current site
Rework the IDO so that it isn't based off of a table but rather a view. Replicate the view definition in all sites.

I don't want to do data replication as there is no reason for the data to "live" anywhere other than where it currently is.

Find more posts tagged with

Syteline Development

Accepted answers

All comments

unknown

The _all tables have data from all sites.

Stephen Cena

One of the requests I have is for a custom table that doesn't have an _all counter part. For those that do, are you saying I use the _all version for the IDO and then make sure to filter using the site_ref?

unknown

Correct. For the other table maybe setup replication? Oh, sorry you don't want to do replication. You could also try a view that references the tables in their sites (UNION).

0911060553270289.pdf

Stephen Cena

Yeah the data is maintained in the main site only. Replication feels like overkill, but if it's the best solution for this I may consider it. I just don't want users updating data. I will look into it.

Jeff Busch

You could create a new IDO for the _mst table, not the view.

That should give you the data across all sites.

Stephen Cena

How though? The IDO reads the table it has defined in it within the current site. How do I make it read tables in a dedicate site?

Rees Howel

Since you're on-premise, you can write your own View upon which to build the IDO. Depending upon whether you want to pull data from all sites or perhaps just the local plus the primary site you can join the datasets together via one or more UNION statements. So something like:

select site_ref, + required columns from dbo.customtable_mst

UNION

select site_ref, + required columns from primarydb.dbo.customtable_mst

and so on.

HTH

Stephen Cena

Right; with a view I fully understand but using the actual _mst tables I don't. I looked and I don't see any way to make an IDO load data from another site or table. Derived fields would work in theory but the performance would be abysmal. I'm trying to understand how the solution would work using just the _mst tables unless I'm misunderstanding the original proposed solution.

Copyright © 2025 Infor. All rights reserved.