Connect Oracle Reports to Ms Sql Server DB


Is it possilbe to Connect Oracle Reports to Microsoft Sql Server database. If yes then how. Please advice.


It is possible to connect Oracle database to MS Sql server database using the Oracle Transparent Gateway for MS SQL Server.
You can use the following links to configure such connection:
Oracle Transparent Gateways - General Description - Part I
Oracle Transparent Gateway for MS SQL Server - Part II

October 11, 2015

Connect Oracle Reports to Ms Sql Server DB

Is it possilbe to Connect Oracle Reports to Microsoft Sql Server database. If yes then how. Please advice. Thanks Sami.It is possible to connect Oracle database to MS Sql server database using the Oracle Transparent Gateway for MS SQL Server. You can

[Forum FAQ] How do I disable all subscriptions without disabling Reporting Services and SQL Server Agent?

Introduction There is the scenario that users configured hundreds of subscriptions for reports. Now they want to disable all the subscriptions, but Reporting Services and SQL Server Agent service should be enable, so the subscriptions will not delive

Oracle 10g/11g to Sql Server 2005 Migration

Dear All, I am a beginner to this migration Activities.. We have designed one Application which is havin Database as Oracle 10g. and We had another small Application which is having Sql Server 2005 has Database. Daily we need to convert DB of Oracle

How To Use Reporting Services On SQL Server 2000 ?

Hi all . Today , I has a issue . Normal , if the customer use SQl Server 2005 , it is no proplem , so if use SQL Server 2000 ,  Now , I want to use Reporting services on SQL Server 2000 , but , I am searching  on Internet , so I know , if I want to u

Oracle 8i to MS SQL Server replication

Im new to Oracle, but a MS SQL Server DBA. Im helping in the architecture of a data warehouse that pulls from some disparate sources, including Oracle 8i, into a SQL Server 2000 box. We could use batch processing to pull updated data from the Oracle

Connection between Oracle 9i and MS Sql Server 2005

Hey Guys, I am hoping to create materialized view of data on a small sql server box using our oralce 9i cluster. Anyway, i have done this with mysql using the standard odbc dirvers and a dblink, but i am having trouble finding an odbc driver for the

Cannot connect to Oracle 11gR2 database from SQL Server 2005

Both SQL Server (Windows) and Oracle (Linux) are in 64bit environments. I have done the following on a Windows 2008 R2 with SQL Server 2005: Install InstantClient from Oracle Database 11g Release 2 Client ( for Microsoft Windows (x64) to C

Need help setting up DB Link from my Oracle 11g XE to SQL Server.

Hi, I'm trying to create a DB Link from my Oracle 11g Express Edition in a Windows XP machine to an SQL Server. Here are the steps I've done so far. 1. Created and setup an ODBC Connection for the SQL Server DB. Named it SQLSERVER. Windows Authentica

Using Before report Trigger with Sql Server

i have used packages in oracle using before report triggers in bi publisher 11g is it possible to do in the same way with sql server ?? don't know much about sql server . any link or documentsHi T.holt, Personally, I don't believe SQL 2008 R2 with AD

Report Services Install - SQL Server 2012 instance blank

I have looked at all the links and tried the suggestions and I am still having the problem:  SCCM 2012 R2                         SQL 2012 SP1 SSRS installed and configured (separate boxes) When I try to add the reporting services role, it finds the

Oracle (Linux) to MS SQL Server 2000 (Windows 2003) with OTG

I have Oracle 9i Release 1 running on linux and i want to use Transparent Gateway to connect to MS SQL Server 2000 running on Windows 2003. Is it possible to setup this connection? If yes, please include the detail approach of installation. Thank you

Oracle 10g dblink to sql server 2005

Hi all, I'm conecting oracle 10g r2 (windows xp) with sql server 2005 (windows 2003 server) After configure ODBC connection to SQLSERVER, the DSN is called HUAWEI_DCDB I configure these three (3) archives: 1) C:\oracle\product\10.2.0\db_1\hs\admin\in

Change Data Capture (CDC) for Oracle by Attunity on SQL Server 2014

hi i've installed the above on my server. It seems to look fine. The connection to oracle database is set, the databases on the sql server side have been created; the tables to be captured are created. When i make a change on the oracle side, the con

Implementing "Temporary Tables" in Oracle after migrating from SQL Server

Hello, Some stored procedures referencing temporary tables in SQL Server were migrated to Oracle. In the Oracle DB, these stored procedures are invalid. In a bid to make them valid, I created the referenced temporary tables in my Oracle DB, via SQL*P

Transfer data from two oracle version to one sql server 2005

Hi, I have two database servers on different machines. They are 1) Oracle 2) Oracle I have to create agents which can transfer tables from these two databases to one machine having sql server 2005 database. Please tell me what are the

Oracle Book for experienced SQL Server developer

Hi everyone I'm looking for suggestions for a book to start with Oracle database development. Though, I'm not looking for a beginner book that starts with explaining what tables, views and procedures are. I'm doing database development on MS SQL Serv

Migrate P6 Pro Rel7 DB from Oracle 10g Express to SQL server 2008

Please advise the steps needed to migrate my P6 Professional Rel7 (laptop) Oracle 10g Express to P6 Enterprise Rel7 (server) migrating over to SQL server 2008. I don't want to lose any of my activity codes during the migration. Thanks in advance for

Getting error while connecting Sharepoint WFE to another Sql Server 2008

Hello All, I am trying to connect a sharepoint wfe to another Sql server 2008 and getting error. This is what I am trying to do. #Disconnecting present database serer Disconnect-SPConfigurationDatabase #Connecting to another database server Connect-S

SCCM coudn't connect to database after recovering SQL server

Hello. Please help to solve a problem. After crashing data storage, i have lost my SCCM and SQL server. I have restored SCCM server as virtual machine and re-install SQL server. I restored old databases to the new SQL server. Same instances and names

Error during database connection to the database : MS SQL Server 2008 R2

Hi All, I am working with ABAP Proxy to Rec JDBC( Integrating XI with MS SQL Server 2008 R2). I am using SAP PI 7.0 I am getting error in RWB at communication channel monitoring : Error during database connection to the database URL 'jdbc:microsoft:s