Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server And Oracle Expand / Collapse
Author
Message
Posted Wednesday, August 4, 2010 4:32 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:22 AM
Points: 742, Visits: 1,053
Hi,

I have a database in SQL Server 2005 that as information that some guys in Oracle need to read.

I told them that their app could connect to our SQL Server and collect all the information they want to and then, their app would store the data in their Oracle Database, but they do not have the knowlegde to connect to SQL Server through the app.


Do you masters have any sugestions?

Thank you




Post #963343
Posted Wednesday, August 4, 2010 4:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 7,131, Visits: 6,292
Depends on the latency requirements and "when" they need the data. Can this be something you transfer to them on a nightly basis using SSIS? Or is this a situation where they need live access?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #963346
Posted Wednesday, August 4, 2010 4:39 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:22 AM
Points: 742, Visits: 1,053
They need to have the access to the data, all the time...
Post #963348
Posted Wednesday, August 4, 2010 4:43 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:22 AM
Points: 742, Visits: 1,053
Maybe i can talk to them to receive the information ony once per day, at night...

Do you have any solutions for this two different situations?
Post #963350
Posted Wednesday, August 4, 2010 6:20 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 15,524, Visits: 27,905
If they need live access you just have to set up a connection either direct through ADO (or whatever) or using another tool such as the Oracle Gateway (it used to be called Transparent Gateway).

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #963405
Posted Wednesday, August 4, 2010 6:25 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:22 AM
Points: 742, Visits: 1,053
What about if they only need to access data once a day? you where talking about making a SSIS? to do what?
Post #963416
Posted Wednesday, August 4, 2010 6:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 15,524, Visits: 27,905
Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old data, to set up an SSIS job to move the data on a daily basis, probably during off-hours.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #963418
Posted Wednesday, August 4, 2010 6:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 7,131, Visits: 6,292
Grant Fritchey (8/4/2010)
Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old data, to set up an SSIS job to move the data on a daily basis, probably during off-hours.


Exactly. Basically, SSIS could export the data in almost any format and then your Oracle people could create a job to load the data nightly into their database.

Though I haven't dealt with Oracle before, you might also be able to use SSIS to directly load Oracle using one of the available connection managers in SSIS. But that would require access to the Oracle DB.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #963442
Posted Wednesday, August 4, 2010 8:11 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 15,524, Visits: 27,905
Brandie Tarvin (8/4/2010)
Grant Fritchey (8/4/2010)
Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old data, to set up an SSIS job to move the data on a daily basis, probably during off-hours.


Exactly. Basically, SSIS could export the data in almost any format and then your Oracle people could create a job to load the data nightly into their database.

Though I haven't dealt with Oracle before, you might also be able to use SSIS to directly load Oracle using one of the available connection managers in SSIS. But that would require access to the Oracle DB.


You can go directly to Oracle from SSIS. There's even a third party destination available to make it really easy to do.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #963498
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse