SolvedPrivate

update Oracle Database via SQL 2008

Posted on 2013-01-28
3
32 Views
Last Modified: 2016-02-10
Hi,
I have application on SQL2008 R2.
I have a form in that application where data has to be transferred  to Oracle Database once the form is completed.

How can I achieve this and can I use SSIS to transfer data ? and how can I trigger the data transfer

Thanks
0
Comment
Question by:expoit
  • 2
3 Comments
 
LVL 6

Expert Comment

by:liija
ID: 38827469
You can do it with SSIS but its better with batch type of jobs. If the data is not needed instantly in Oracle, you could easily schedule SSIS package to be run once a hour. Or SSIS can also be run from command line, with required parameters, with dtexec utility.
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

For up-to-date integrations MS BizTalk is better product. SSIS is not initially designed to be used like that.
0
 

Author Comment

by:expoit
ID: 38827603
Do you have any guide where i can create the SSIS package from SQL to Oracle.
and is there a way where I could trigger the data transfer of change of a field.
0
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38827668
Creating package for oracle is not different from creating one for SQL Server. You only define the connection to be Oracle for the output.

You could use the dtsx.exe to trigger the package. Read through the msdn ducumentation.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Abstract Express Replacement Software 12 23
Querying data from 3 SQL tables 2 31
SQL Insert parts by customer 12 32
Return 0 on SQL count 24 28
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question