Consolidation of data

Lars Pelzer

Hi all,

Is it possible with CoreSuite Designer to consolidate data from multiple SBO administrations in 1 layout?
So that data from multiple administrations can be displayed in 1 layout.

Actually the question is:
Can Coresuite work with multiple databases at the same time?

Thank you in advance!

Greetz
Lars

Philipp Knecht

Hi Lars

The Answer is Yes.
In SQL Queries you have the possibility to prefix a tanblename with the Tablename. This is the way to go.

hth

Lars Pelzer

Hi Philipp,

So I can build queries like:

SELECT T0.CardCode
FROM DB1.OCRD T0

UNION

SELECT T0.CardCode
FROM DB2.OCRD T0

Coresuite uses the engine from the Microsoft SQL Server?

Thanks in advance!

Greetz
Lars

Philipp Knecht

Hi Lars

Yes exactly.
coresuite uses ADO.NET SQL Provider for reading purposes which is pretty fast.
-> Every Query which works in Query Analyzer will work in coresuite too.
(Thats why you need to enter the SQL Credentials when installing coresuite for the first time)

hth

Lars Pelzer

Thank you for your time and very useful information!

Greetz
Lars