Class Outline – Databases: Corepoint Integration Engine

Day 1

Database Connectivity

  • Discussion of the database configuration objects necessary to connect to a database
    • Data Point
    • Namespace
    • Association
    • Database Actions

Write to a Database

  • Create the database objects and an action list to store data from a message into a database table using the DBSelect, DBInsert and DBUpdate actions
  • View the updated table in Microsoft SQL Server Management Studio

Read from a Database

  • Create a new action list using the DBSelect and ForEach actions to create a new message from a database table
  • Create a sender connection with a runtime frequency of every 30 secs to send the message
  • Edit the database configuration objects and modify the action list to add data from another table to the message

Delete records from a database

  • Create an action list and use the DBDelete action to delete records from a database
  • Create a Gear-to-Gear connection and a connection schedule to establish when the connection should run

DBLogMsg

  • Instructor demo and discussion of how to use the DBLogMsg action 

Day 2

Database vs Code Sets & Correlations

  • Instructor demo and discussion of the benefits of using a database to maintain a code set

Update Database Objects

  • Add a column to a database table
  • Update the database objects and action list to reflect the change to the database

Use Stored Procedures

  • Discussion of using stored procedures in a database
  • Use the DBCall and ListCopy actions to call a stored procedure to create and send HL7 messages

Handle Database Connectivity Issues

  • Modify an action to retry querying the database in the event of intermittent connectivity issues
  • Use the Loop, TryCatch and ItemExpr actions to set the number of interations to check for database errors

Use non-SQL Server Databases

  • Discusson of supported databases
 Print Friendly