Building Database Interfaces
Iguana Training Series. Explore techniques for connecting to and interacting with databases.
This course is part of the Iguana Training Series, a set of private courses that cover an array of interfacing concepts in Iguana. It is recommended that you have at least completed the Building An HL7 Interface course to understand basic concepts repeated in this course.
Connecting to databases is often a critical component in interfacing workflows. In this course, we'll discover how easy it is to send data in and send data out from databases from our interface.
Some of the concepts we will cover include:
- How do we make connections? And what are our options for interacting with the database?
- What is the role of a tables VMD file in inserting data into a database?
- What are some techniques that can help us when we are testing our database interfaces?
- How do we make our interfaces more robust when the database is unavailable?
|Getting set up|
|About our project||00:05:00|
|Create database channel||00:08:00|
|Export sample data from the logs||00:05:00|
|Import the starting project||00:05:00|
|Creating database and tables in SQLite||00:04:00|
|HL7 to database|
|Connect to database||00:08:00|
|Build the to-database code||00:10:00|
|Map the fields from HL7 to Database||00:10:00|
|Put the merge logic in||00:03:00|
|Run the database channel||00:10:00|
|What happened to the data?||00:05:00|
|Why do we use tables.vmd?||00:08:00|
|Verify data reached the database||00:05:00|
|Database to HL7|
|Understanding the concept of seeding||00:03:00|
|Build Translator-to-LLP channel||00:05:00|
|Add ‘From Translator’ polling component||00:10:00|
|Import the sample data||00:08:00|
|Write the filter component||00:10:00|