This forum is specifically for PMPC, could you please post the same question in the PC community?
The question is: what actually is a SQL Server Availability group?
You better raise a service request at Informatica Global Customer Support to get formal confirmation or denial. I fear there may be not too many persons around who can really answer your question off the top of their heads.
1 of 1 people found this helpful
According to this KB it might work configuring MultiSubnetFailover and ApplicationIntent since Informatica 10.1.1 HF2:
Here there are some indications from Data Direct:
Be aware this does not work for the domain's database:
Please, let me know if this information helps you.
In addition to the post of David.
To increase the resilience for network delays you might need to set parameters on the domain.
MasterDBRefreshInterval for a single node domain.
See the support document for a multi node domain.
We have a single node domain.
Informatica states, it doesn't support it for the domain db. repository db should work.
THe dba team still will try to make it work. They state it connect's to an AG listener and it probably will work.
So any tips about it.
for now the options from JanLeedert and David helped a lot.
One thing worth mentioning (though you and your DBAs won't like it) is that this - even though it may seem to work for the time being - is an UNSUPPORTED combination. Which means that if anything fails (and I mean: ANYTHING), you are on your own. Informatica reserves the right to deny support for such a setup.
For example, let's suppose the domain seems to work now, but in 3 weeks all of a sudden your production system goes down. And guess what? As soon as you tell Informatica support your setup, they will say, please move to a supported combination (i.e. no AG for the domain DB), only then can we help you. And lo and behold, after you have switched to an AG-less setup, everything works fine. And no one can find a reason why it works now and does no longer work with an AG setup.
Do your managers really want to risk this?
Just my 2 cents.
I know I sound pernickety and paranoid, but I've seen too many cases where even a slight deviation from the "supported paths" led to disasters. My interest is to save you from that hassle.