Single query across multiple connection profiles.
search cancel

Single query across multiple connection profiles.

book

Article ID: 385339

calendar_today

Updated On:

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.