View source for DB Conversion Library

[[Category:Function libraries]]
'''Type:''' Library, Extra

Lets you embed data obtained from a database into the Analytica model. This breaks the need to use it with an external database, so -- for example -- you can send it to someone (e.g. Lumina tech support) who does not have access to the database or has an edition of Analytica (e.g. Professional) that doesn't support database access.

Press a button in this library to transform all the variables defined using [[DbQuery]], [[DbLabels]] and [[DbTable]] to literal data. Variables and indexes defined using [[DbQuery]] or [[DbLabels]] are transformed to list definitions, and those defined using [[DbTable]] are transformed into edit tables. This breaks the connection to the external database. So, of course, the model will no longer be able to get new or extended data from the database.

The library is limited in its scope. It only works when all calls to [[DbQuery]], [[DbLabels]] and [[DbTable]] occur at the top level of variable definitions. Do not try to use it if the calls to these functions are embedded within larger expressions or in [[User-Defined Functions]].

'''''Use with extreme caution!!''''': Make a copy of your original model ''before'' adding and executing this module. After running the transformation, be sure to use '''File &rarr; Save As...''' to save the transformed model under a different filename, so you don't clobber your original model.

'''Download:''' [[Media:Db conversion lib.ana|DB conversion lib]]

'''Keywords:''' [[Examples and libraries by topic#Data import and cleaning|Data import and cleaning]]

== See Also ==
* [[Examples and libraries by topic]]
* [[Libraries table]]
* [[DbQuery]]
* [[DbLabels]]
* [[DbTable]]
* [[Additional libraries]]