User Profile
Stefanssce
Copper Contributor
Joined Dec 08, 2020
User Widgets
Recent Discussions
Re: SQL Server 2022 create external data source with Oracle TNS files (introduced with CU2)
After a lot of try and error I managed to get it working. Here the example which might help others: --SQL CREATE EXTERNAL DATA SOURCE OracleSource WITH ( LOCATION = 'oracle://ORA_TEST' , connection_options = 'ServerName=ORA_TEST;TNSNamesFile=C:\ORA\TNS_ADMIN\tnsnames.ora', PUSHDOWN = ON, CREDENTIAL = cred_oracle) --TNSNAMES.ORA which is store in C:\ORA\TNS_ADMIN ORA_TEST = (DESCRIPTION = (CONNECT_TIMEOUT = 3) (ENABLE = BROKEN) (ADDRESS = (PROTOCOL = TCP)(HOST = oracle1.yourdomain.net )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = oracle2.yourdomain.net )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORA_TEST) ) )1.9KViews0likes0CommentsSQL Server 2022 create external data source with Oracle TNS files (introduced with CU2)
Hi, I am trying to set up an external data source to connect to Oracle. This works fine when I specify the Oracle hostname like "LOCATION = 'oracle://oracle1:1521". In our setup we normally us TNS where there are two servers specified. oracle1 and oracle2. In case of a failover the connection uses the server which is online. In the working example above I cannot use of this option and the external table will fail if the database is running on oracle2. I can read in the documentation that with CU2 in SQL 2022 there was an option introduced to use TNS and I hope this will solve this problem. However, the documentation is vague about how to use it and I do not find other documentation about the "feature". Could anyone give an example how to use this option to be able to use the "Oracle" failover option? Thanks. StefanSolved2.1KViews0likes1CommentIssue with Integration Runtime in Azure Data Factory and Proxy
Hi, I am using Web Table in a Linked Service and that was working fine with older version av Integration Runtime (v4) with Proxy. I hade the proxy configured in "Microsoft.Mashup.Container.NetFX40.exe.config" and it was picking it up without a problem and to then connect to the website configured in the "Web Table". Now with v5 av Integration runtime this same setting does not work. When doing a "Test Connection" I can see the process starting "Microsoft.Mashup.Container.NetFX40.exe" but it tries to reach the website directly without using the proxy. That fails with the error: 'Type=Microsoft.Data.Mashup.MashupValueException,Message=The server or proxy wasn't found.,Source=Microsoft.Data.Mashup.ProviderCommon,' Has anyone seen the same issue and maybe solved it? Thx. Stefan941Views0likes0Comments
Recent Blog Articles
No content to show