Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Liberate your data.
Skip main navigation (Press Enter).
Data Company Central
Data Company Summits 2022
Data Company Conference 2021
Become a Champion!
Back to discussions
sort by most recent
sort by thread
01-02-2019 02:01:00 PM
We have single application instance hosted on a server and we have multiple vdbs using Delphix which...
01-02-2019 02:26:00 PM
Hi Suja, An interesting question. Really the answer lies with the application tier. There is no n...
Posted 01-02-2019 02:01:00 PM
We have single application instance hosted on a server and we have multiple vdbs using Delphix which contains different type of test data.
Can I connect my application instance to multiple vdbs and route the DB calls appropriate as per test data requirement.
RE: Database routing
Posted 01-02-2019 02:26:00 PM
An interesting question. Really the answer lies with the application tier. There is no native way within Delphix to direct traffic. The answer would be exactly the same as if you had physical databases. A VDB is just a database at the end of a connection string, your application would have to determine which connection it made.
If you wanted to run these tests automatically against different datasets based on a schedule rather than in real-time then I'd suggest taking a look at the Self-service
capability (or bookmarking).
Branching allows you to store different versions of data in a minimal storage footprint and alter the version using the self-service interface (activate a branch) or using the public REST API. In this way you can maintain a single connection string but alter the database data by activating different branches. Since this can be done using our self-service API - or even better through Marcin Przepiorowski's wonderful dxToolkit a wrapper around the REST API's implemented in Perl or as an executable) - you can implement an automated test strategy without ever having to talk to a DBA (I exaggerate here of course, for effect). In this way by establishing based on the test criteria what test data you need you can activate programmatically the correct set of data by activating the appropriate Branch.
The Self-service concepts are detailed
The dxToolkit is
I hope that helps.
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
DevOps & CI/CD
Test Data Management
Compliance & Security
Site Reliablity Engineering
Financial Services & Banking
Australian Securities Investment Commission
California Privacy Rights Act (CPRA)
CI / CD Pipeline
Continuous Delivery (CD)
Continuous Integration (CI)
Data Protection Authority (DPA)
Hong Kong Monetary Authority
Japan Personal Information Protection Act
Maryland Personal Information Protection Act (PIPA)
Massachusetts Data Protection Law
NY SHIELD Act
Test Data Management
© 2022 Delphix
Copyright 2020. All rights reserved.
Powered by Higher Logic