Scenario 2: .NET via SQL Server

CONNX Data Integration Suite 14.8.0 | Enterprise Planning Guide | CONNX Scenarios | Scenario 2: .NET via SQL Server

This scenario shows a .NET application using the SQL Server Provider connecting to RMS on VMS via an SQL Server linked server and SQL Server on Windows. This .NET application indirectly uses CONNX via SQL Server linked server technology.

In this scenario, the desktop app has a direct connection to an SQL Server provider. The SQL Server Provider has a remote connection to an SQL Server. The SQL Server has a direct connection to the CONNX OLE DB through an SQL Linked server. The CONNX OLE DB has a direct connection with the CDD and remote connections to the CONNX License server and the CONNX server.

With CONNX, a legacy data source is accessed as if it were just another relational table. The user can create stored procedures and other routines as if the disparate data sets all belonged to the same database. CONNX provides the seamless connectivity and access to the legacy data source.

In this scenario, the CDD is on the user's machine. This is typical in a development environment where CDD changes are stored on the user's local machine, and propagated to the server when development is complete. In the production environment, move the CDD closer to the CONNX Client, or to a dedicated file server.