Landmark Replication Sets - Do Replication Sets support SQL Queries?

Hans Mueller

From our call on 6/3 - do replication sets support using SQL queries where you could join business classes instead of just exporting individual business classes?  What about inner and outer joins?

Hans Mueller

Answers provided during the call:

1. You can use the Infor delivered relations between business classes to select data from more than one business class in a Replication Set.
2. You can also create your own relationships between business classes using the Rich Client and Configuration Console, and then use those configured relations as part of your Replication Sets.
3. You should be aware that the more relations you add to your Replication Set, the slower the replication set run will be.
4. If you would like to do SQL queries on the replication sets beyond what you can do with Derived fields and Relations, then sending the replication set to ION and using Compass would be a good way to do so.