SQLImport multiple tables with associations
Hans Karlsen (talk | contribs) No edit summary |
Hans Karlsen (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
When importing data with [[Import data from other SQL servers|SQLImport as described here]] you may need to import two or more tables and set up associations between them. For value stores with limited set of objects you can do just as with Tab data import and set up comboboxes for singlelinks in the import grid. This will effectively tie objects together. | When importing data with [[Import data from other SQL servers|SQLImport as described here]] you may need to import two or more tables and set up associations between them. For value stores with limited set of objects you can do just as with Tab data import and set up comboboxes for singlelinks in the import grid. This will effectively tie objects together. | ||
But if both tables have a large amount of rows it is not ideal to have one table in a Combobox to choose from. In this case consider to import enough keys as attributes in your objects - and as a | But if both tables have a large amount of rows it is not ideal to have one table in a Combobox to choose from. In this case consider to import enough keys as attributes in your objects - and as a separate step tie the objects together either with another ServerSIde job - or with an [[OCLOperators sqlpassthrough|SQLPassthrough]] like this: | ||
Revision as of 15:12, 29 November 2018
When importing data with SQLImport as described here you may need to import two or more tables and set up associations between them. For value stores with limited set of objects you can do just as with Tab data import and set up comboboxes for singlelinks in the import grid. This will effectively tie objects together.
But if both tables have a large amount of rows it is not ideal to have one table in a Combobox to choose from. In this case consider to import enough keys as attributes in your objects - and as a separate step tie the objects together either with another ServerSIde job - or with an SQLPassthrough like this:
This page was edited 96 days ago on 02/10/2024. What links here