SolvedPrivate

update Oracle Database via SQL 2008

Posted on 2013-01-28
3
29 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now