How to Add alternate host in ADF linked service?

Question

We are adding a DR environment in our on prem Oracle database, how can we include alternate host in ADF linked service.

Answer 1

Hi @Chilla, Vishwanatha

I have had the same issue and was able now to solve it with adding an additional connection property "alternateservers" Here you can provide multiple additional servers for you connection.

Property name: AlternateServers
Property value: (HostName=<secondary host>:PortNumber=<secondary port>:ServiceName=<secondary service name>)

Or if you use a SID connection type
Property value: (HostName=<secondary host>:PortNumber=<secondary port>:SID=<secondary SID name>)

You can even add mutliple additional servers only by concatenating the entries with addtional ":"

I found that this solution is already described in the documentation in the section "Linked service properties" :
https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory

Here you can find a screenshot, how to add that additional parameter:

Answer 2

Hi @Chilla, Vishwanatha ,

Thank you for posting query in Microsoft Q&A Platform.

It seems you are trying to make your Oracle database linked service dynamic, so that you can point to DR database also dynamically. Please correct me if its not the case.

If above statement is correct, then you should consider having parameters created inside your linked service and use them.

You can refer below links to know about parameterizing linked services.

• https://learn.microsoft.com/en-us/azure/data-factory/parameterize-linked-services?tabs=data-factory
• https://www.youtube.com/watch?v=M22Mj0rcBcs

In below screenshot I created parameters called "Hostname" & "SID" and used that parameters inside linked service. Similarly you can create more parameters and use for what ever configuration you want inside linked service.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators