XML As A Source

With Treasury Bank ERP, can link to your institution to import and export XML as a data source to fulfill two main tasks:

  • Support integration with locally available XML data.
  • Receive and transfer data as XML from remote systems.

Insight uses a number of different technologies to support these two tasks:

Local Files

Your institution can read XML data directly from local files using either a Time or a File Integration Process. 

A Time Integration Process is used periodically to read a file of a fixed name. For example, you could define a Time Integration Process to read an XML prices and values list document that is replaced on a nightly basis.

A File Integration Process is used to read files as they are added to a specific location. For example, you could define a File Integration Process to read XML order documents when they are placed into a receiving directory by a Web page.

Files Via File Transfer Protocol (SFTP) Or Hypertext Transfer Protocol (HTTP)

Institutions can read XML remotely from an FTP, SFTP or HTTP address. User names and passwords are supported, so you can secure your sources, with token and API.

To read XML remotely, use a Time Integration Process that you define to periodically check the address for a given file.

Message Queues (Using Dynamic File)

You entity of jobs

Your institution can read XML from public or private MSMQ message queues using a Queue Integration Process. The Console uses MSMQ messages and Queue Integration Processes to support additional types of XML data sources: Email (POP3), ASP, and Publishers and Publishing Adapters.

In addition, you can generate XML using the following originators and receivers that integrate with Treasury Bank®

Email (POP3)

Institutions can read XML from POP3 based email boxes using the Email Bridge. The Email Bridge extracts XML from an email’s body or attachment and places it in an MSMQ message queue, which is then processed by a Queue Integration Process.

ASP

Institution can read XML that was sent using HTTP Post to an ASP page for processing. Two sample ASP pages are installed under *\Public\Public Documents\Scribe\Samples\Scripts:

  • XMLBridgeToFile.ASP — Receives XML data and then persists it to a local file for processing by a File Integration Process.
  • XMLBridgeToQueue.ASP — Receives XML data and then persists it to a MSMQ message queue for processing by a Queue Integration Process.
Chief Treasurer

Marcellus Scott is the Chief Treasurer and banker for Treasury Bank Organization. He designs and build investment partnerships and trust with community organization and families.