<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
SQL Server And Oracle
SQL Server And Oracle
Rate Topic
Display Mode
Topic Options
Author
Message
river1
river1
Posted Wednesday, August 04, 2010 4:32 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
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
Brandie Tarvin
Brandie Tarvin
Posted Wednesday, August 04, 2010 4:36 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668,
Visits: 5,695
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, MCDBA, MCSA
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
river1
river1
Posted Wednesday, August 04, 2010 4:39 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
They need to have the access to the data, all the time...
Post #963348
river1
river1
Posted Wednesday, August 04, 2010 4:43 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
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
Grant Fritchey
Grant Fritchey
Posted Wednesday, August 04, 2010 6:20 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383,
Visits: 25,189
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
river1
river1
Posted Wednesday, August 04, 2010 6:25 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
What about if they only need to access data once a day? you where talking about making a SSIS? to do what?
Post #963416
Grant Fritchey
Grant Fritchey
Posted Wednesday, August 04, 2010 6:29 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383,
Visits: 25,189
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
Brandie Tarvin
Brandie Tarvin
Posted Wednesday, August 04, 2010 6:52 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668,
Visits: 5,695
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, MCDBA, MCSA
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
Grant Fritchey
Grant Fritchey
Posted Wednesday, August 04, 2010 8:11 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383,
Visits: 25,189
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
