Gateways Brick

Home > Architecture Library > Review by Architecture Type > Technology Architecture > Gateways Brick

Description

There are two types of gateways:

1. Database gateways enable access to heterogeneous Database Management Systems (DBMS), usually through a common Structured Query Language (SQL) interface.

2. Communications middleware gateways connect Message-Oriented Middleware (MOM) products on the market.

Database gateways enable connectivity to heterogeneous DBMS engines, sometimes including non-relational databases, using a common Application Programming Interface (API), usually SQL, and protocol.

Brick Information
Tactical (0-2 years)	Strategic (2-5 years)
fmSQL Synch Linked-Server Database Gateway (SQLServer to Oracle or SQLServer to DB2) Oracle Transparent Gateway (Oracle to DB2)
Retirement (To be eliminated)	Containment (No new development)

Baseline (Today)	Emerging (To track)
fmSQL Synch Linked-Server Database Gateway (SQLServer to Oracle or SQLServer to DB2) Oracle Transparent Gateway (Oracle to DB2)

Comments

Tactical and strategic products were selected to leverage NIH's investment in products that are a proven fit for NIH's known future needs. Leveraging baseline products in the future will minimize the operations, maintenance, support and training costs of new products.
Some baseline products have been designated retirement and containment. These products are either not as widely or successfully deployed at NIH, or they do not provide as much functionality, value, or Total Cost of Ownership as the selected tactical and strategic products.
fmSQL Synch may be used for synchronization of the FileMaker Pro databases with Microsoft SQL Server.