Blue chip professional skills from an independent

Table link

Table link allows elements and documents to be loaded in bulk.

The CODA database has a set of tables called the link tables which can be freely written to by third party applications.

Once the data is written, you can trigger CODA to load it into the core database. The table link function itself can be considered as 'protecting' the main database from bad data.

The general upshot is you can safely write any data to the link tables - CODA itself will identify any errors and will refuse to load poor quality data.

It is worth noting that you do not need a separate licence for table link - it comes 'free' with the standard CODA licence; whilst in use it will consume a user licence slot, but there is no separate licence to purchase (as there is for XMLi or callable link).

What can it do?

Table link exists to load documents and elements into CODA. It is especially useful for large quantities of data, for example:

  • data migrations;
  • overnight batch loads.

It is optimised for such tasks - and is thus the fastest way to safely load data into CODA. On modern servers, even with multimillion document databases, table link can happily cope with loading millions of document lines over night. Few regular batch loads will need this volume, but it is very useful for one off data migrations from other systems.

How does it do it?

You load data into the link tables, and flag it as 'ready to process'. You then ask ('trigger') CODA to process it, via one of four methods:

  • from a menu item within the CODA application (either browser or client server editions);
  • with the 'command line' utility oas_dtl (for documents) and oas_etl (for elements);
  • with XMLi (and thus web services);
  • with callable link.

How can we help?

  • Using table link is a core skill for us. We know:
  • how to populate the table link tables with the correct data to achieve the desired outcome for documents and elements loaded into CODA;
  • which 'trigger' methods to use in which circumstances;
  • how to interpret the results that CODA returns, and especially in the case of problems;
  • useful strategies to adopt when there are problems, in the context of re-presenting data to load again;
  • how to avoid any locking issues in connection with concurrent table link 'runs'.

In addition, we have plenty of experience of building an end-to-end solution between third party data feeds and CODA - including data translations, aggregation and mapping.

We are also happy to provide training courses for developers. We find these are generally better tailored for your specific needs, and carried out with a hands-on approach at your offices, rather than a classroom based format.

Please contact us for more details, and initial indications of prices for any size of project. We are very happy (and generally prefer) to provide a fixed price quotation.