Outbound Pipeline - Revision history

AdminJo at 14:27, 15 May 2025

2025-05-15T14:27:18Z

← Older revision		Revision as of 14:27, 15 May 2025
Line 17:		Line 17:
	* SFTP: Secure File Transfer Protocol.		* SFTP: Secure File Transfer Protocol.

	[[File:Outbound Pipeline Overview.png\|border\|999x850px]]		[[File:Outbound Pipeline Overview.png\|border\|999x850px\|frameless]]

	== Databases ==		== Databases ==

AdminJo at 14:26, 15 May 2025

2025-05-15T14:26:17Z

← Older revision		Revision as of 14:26, 15 May 2025
Line 17:		Line 17:
	* SFTP: Secure File Transfer Protocol.		* SFTP: Secure File Transfer Protocol.

	[[File:Outbound Pipeline Overview.png\|border\|~~850x850px~~]]		[[File:Outbound Pipeline Overview.png\|border\|999x850px]]

	== Databases ==		== Databases ==

AdminJo: /* Application: Protocol queue reader */

2025-04-30T08:29:06Z

Application: Protocol queue reader

← Older revision		Revision as of 08:29, 30 April 2025
Line 97:		Line 97:
	In this document, any '''subscriber database''' mentioned may be any of the above three schemas, ''except'' when a subscriber database is hosted by a third party, in which case the database will always be the newest schema.		In this document, any '''subscriber database''' mentioned may be any of the above three schemas, ''except'' when a subscriber database is hosted by a third party, in which case the database will always be the newest schema.

	== ~~Application:~~ Protocol queue reader ==		== Protocol queue reader ==

	* Same Queue Reader application as used for [[Inbound Pipeline]], but configured to run as a Protocol Queue Reader.		* Same Queue Reader application as used for [[Inbound Pipeline]], but configured to run as a Protocol Queue Reader.

AdminJo: /* Databases */

2025-04-29T13:37:03Z

Databases

← Older revision		Revision as of 13:37, 29 April 2025
Line 31:		Line 31:
	!Description		!Description
	\|-		\|-
	\|~~<s>~~Admin~~</s>~~		\|Admin
	\|~~<s>~~MySQL~~</s>~~		\|MySQL
	\|~~<s>~~Stores details on services publishing to and subscribing from the VHP~~</s>~~		\|Stores details on services publishing to and subscribing from the VHP
	\|-		\|-
	\|Audit		\|Audit
Line 39:		Line 39:
	\|Stores audit of published data and transformations to it		\|Stores audit of published data and transformations to it
	\|-		\|-
	\|~~<s>~~Config~~</s>~~		\|Config
	\|~~<s>~~MySQL~~</s>~~		\|MySQL
	\|~~<s>~~Stores most configuration including database connection strings, logging, RabbitMQ routing~~</s>~~		\|Stores most configuration including database connection strings, logging, RabbitMQ routing
	\|-		\|-
	\|Data_generator		\|Data_generator
Line 55:		Line 55:
	\|Stores all patient and reference data in FHIR JSON. There is support for multiple ehr databases, with each publishing service configured to write to a specific ehr (many to one)		\|Stores all patient and reference data in FHIR JSON. There is support for multiple ehr databases, with each publishing service configured to write to a specific ehr (many to one)
	\|-		\|-
	\|~~<s>~~Enterprise~~</s>~~		\|Enterprise
	\|~~<s>~~MySQL~~</s>~~		\|MySQL
	\|~~<s>~~Original schema of the “subscriber” customer database for storing patient records in a relational format. Also known as “compass” or “compass v1”. There are multiple instances of this database, each for a specific customer.~~</s>~~		\|Original schema of the “subscriber” customer database for storing patient records in a relational format. Also known as “compass” or “compass v1”. There are multiple instances of this database, each for a specific customer.
	\|-		\|-
	\|Subscriber		\|Subscriber

AdminJo: /* Databases */

2025-04-29T13:25:43Z

Databases

← Older revision		Revision as of 13:25, 29 April 2025
Line 31:		Line 31:
	!Description		!Description
	\|-		\|-
	\|Admin		\|<s>Admin</s>
	\|MySQL		\|<s>MySQL</s>
	\|Stores details on services publishing to and subscribing from the VHP		\|<s>Stores details on services publishing to and subscribing from the VHP</s>
	\|-		\|-
	\|Audit		\|Audit
Line 39:		Line 39:
	\|Stores audit of published data and transformations to it		\|Stores audit of published data and transformations to it
	\|-		\|-
	\|Config		\|<s>Config</s>
	\|MySQL		\|<s>MySQL</s>
	\|Stores most configuration including database connection strings, logging, RabbitMQ routing		\|<s>Stores most configuration including database connection strings, logging, RabbitMQ routing</s>
	\|-		\|-
	\|Data_generator		\|Data_generator
Line 47:		Line 47:
	\|Staging area for sending transformed data to externally hosted databases		\|Staging area for sending transformed data to externally hosted databases
	\|-		\|-
	\|~~Ehr~~		\|Data_sharing_managers
			\|???
			\|????
			\|-
			\|EHR
	\|MySQL		\|MySQL
	\|Stores all patient and reference data in FHIR JSON. There is support for multiple ehr databases, with each publishing service configured to write to a specific ehr (many to one)		\|Stores all patient and reference data in FHIR JSON. There is support for multiple ehr databases, with each publishing service configured to write to a specific ehr (many to one)
	\|-		\|-
	\|Enterprise		\|<s>Enterprise</s>
	\|MySQL		\|<s>MySQL</s>
	\|Original schema of the “subscriber” customer database for storing patient records in a relational format. Also known as “compass” or “compass v1”. There are multiple instances of this database, each for a specific customer.		\|<s>Original schema of the “subscriber” customer database for storing patient records in a relational format. Also known as “compass” or “compass v1”. There are multiple instances of this database, each for a specific customer.</s>
	\|-		\|-
	\|Subscriber		\|Subscriber

AdminJo at 09:32, 29 April 2025

2025-04-29T09:32:40Z

← Older revision		Revision as of 09:32, 29 April 2025
Line 13:		Line 13:
	* Not all databases shown.		* Not all databases shown.
	* Interaction with databases simplified.		* Interaction with databases simplified.
			* AMPQ: Advanced Message Queuing Protocol.
			* JDBC: Java Database Connectivity.
			* SFTP: Secure File Transfer Protocol.

	[[File:Outbound Pipeline Overview.png\|border\|850x850px]]		[[File:Outbound Pipeline Overview.png\|border\|850x850px]]

AdminJo at 09:04, 29 April 2025

2025-04-29T09:04:42Z

← Older revision		Revision as of 09:04, 29 April 2025
Line 289:		Line 289:
	!Value		!Value
	\|-		\|-
	\|~~<s>~~Component type:~~</s>~~		\|Component type:
	\|~~<s>~~Tomcat servlet and ~~Angular4~~ frontend ~~(will be migrated to Angular8)</s>~~		\|Tomcat servlet and a VUE v3 frontend
	\|-		\|-
	\|~~<s>~~Code location:~~</s>~~		\|Code location:
	\|~~<s>'''enterprise-web''' module in '''Enterprise'''~~ repository~~</s>~~		\|RecordViewer repository
	\|-		\|-
	\|~~<s>~~Arguments:~~</s>~~		\|Arguments:
	\|~~<s>ID~~ for ~~config table~~ record provided by web.xml ~~in war file</s>~~		\|record-viewer app_id for configuration record provided by web.xml
	\|}		\|}

AdminJo at 08:57, 29 April 2025

2025-04-29T08:57:52Z

Show changes

AdminJo at 16:21, 25 April 2025

2025-04-25T16:21:11Z

← Older revision		Revision as of 16:21, 25 April 2025
Line 291:		Line 291:
	!Value		!Value
	\|-		\|-
	\|Component type:		\|<s>Component type:</s>
	\|Tomcat servlet and Angular4 frontend (will be migrated to Angular8)		\|<s>Tomcat servlet and Angular4 frontend (will be migrated to Angular8)</s>
	\|-		\|-
	\|Code location:		\|<s>Code location:</s>
	\|'''enterprise-web''' module in '''Enterprise''' repository		\|<s>'''enterprise-web''' module in '''Enterprise''' repository</s>
	\|-		\|-
	\|Arguments:		\|<s>Arguments:</s>
	\|ID for config table record provided by web.xml in war file		\|<s>ID for config table record provided by web.xml in war file</s>
	\|}		\|}

AdminJo at 16:17, 25 April 2025

2025-04-25T16:17:01Z

← Older revision		Revision as of 16:17, 25 April 2025
Line 222:		Line 222:

	* When subscriber DB is remotely hosted, this application is used by the third party in their hosted environment		* When subscriber DB is remotely hosted, this application is used by the third party in their hosted environment
	* Downloads CSV data from the ~~DDS~~ SFTP server		* Downloads CSV data from the VHP SFTP server
	* Applies the CSV data to the subscriber DB in this hosted environment		* Applies the CSV data to the subscriber DB in this hosted environment
	* Writes back feedback files to report outcome of the above		* Writes back feedback files to report outcome of the above
Line 243:		Line 243:
	'''Processing steps:'''		'''Processing steps:'''

	# Connect to ~~DDS~~ SFTP server		# Connect to VHP SFTP server
	# Download any new files and write to local disk		# Download any new files and write to local disk
	# Decrypt CSV files		# Decrypt CSV files