Single query across multiple connection profiles.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Due to a new architectural design we should be able to read from 2 PostgreSQL DBs from the same SQL query to generate synthetic test data.

Environment

Portal Version: 4.11.102.0

Datamaker Version: 4.11.15.0

Cause

NA

Resolution

Cannot execute single query across multiple connection profiles. Such scenarios can be solved on the database level by "linking" one database to another (of the same type of course).

Oracle and SQL Server support this, not sure about PostgreSQL which you are using.