SQL Consulting | Connect SQL Server To Oracle

Connect SQL Server To Oracle http://www.ReportingGuru.com
This video shows how to connect SQL Server to Oracle with Linked Servers. Email us at ReportingHelp@ReportingGuru.com if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759

Reporting Guru is a US based development company with all resources located in the US. We have many senior level developers with over a decade of development experience.

We offer the following services:
Custom Report Writing | Consulting | Database Development & Integration.

Some of our specialties are:

--SQL Server Reporting Services SSRS / SQL Server / SQL Server Integration
--Services SSIS / SQL Server Analysis Services SSAS
--Custom Application Development / Maintenance
--Oracle
--MySQL
--Crystal Reports / Business Objects
--BIRT
--.NET Development
--PHP Development
--SharePoint
--Microsoft Dynamics
--Access
--Excel and Pivot Tables
--More!

CUSTOM REPORT WRITING
Our experienced data report writers take your report & business requirements to build the custom reports you need. We deliver reports on demand or on a timed schedule.

CONSULTING
When your data and reporting team needs guidance or whether you need to build new reports, convert reports, enhance existing reports or need advice on finding the right reporting solution for your business ReportingGuru is here to help.

DATABASE DEVELOPMENT & INTEGRATION
We create and develop the necessary structure to house business data in a clear and easily accessible manner, so you have the tools to pull the reports you need easily.

CUSTOM SOFTWARE & APPS
We also offer custom applications for our clients like our Dashboard Guru and Quickbooks Enterprise Connector http://www.reportingguru.com/products/. Reporting Guru's dashboarding software will give interactivity to static web based reports. Our Quickbooks Connector will pull data from Quickbooks into a database for custom reporting purposes.

Please let us know if you would like to discuss your requirements or issues free of charge. Our process is taking your requirements and suggesting the best architecture or approach without trying to sell you any specific software. We work as needed and only charge for the hours we work. We do not charge a retainer and there is no minimum charge.

Connect SQL Server To Oracle http://www.ReportingGuru.com
Email us at ReportingHelp@ReportingGuru.com or call 1-(800) 921-4759.

---

Closed Caption:

in this video I want to talk about how
to connect sequel server to an Oracle
database and for our purposes we're
going to just connect link we're going
to link servers to connect to the Oracle
database so first off you need to go to
the or goal server the server that
actually has oracle installed on it and
go into windows services and you'll see
the Oracle Service and the name of the
Oracle instance there in the service
name so EXCI here so then we could then
connect to it with something like sequel
plus x going into the Oracle
oracle installation area and you can go
to sequel plus and actually connect to
it to make sure you can connect and here
you can see I just a simple select
statement where I selected all from CA T
and then I ended it with the semicolon
so that would run so now you want to go
to the machine that is going to cat to
oracle you whether that's the same
machine you're on here or it's a
different machine in our case we have a
different machine that or that sequel
server is installed on that we're going
to connect to
so let me pull that one up and so here's
our sequel server machine so first off
I'm we back up a little bit and you just
tell you what you need to install you
want to install the oracle client so I'm
gonna let me put this up on the screen
ok so this is the oracle client that you
want to install on the machine you want
to connect to oracle and so really all
you need to do is install the 64 bit
contains oracle client libraries
download if you want to install the
client libraries only so this is really
the only thing you need to install you
can then do on a blank installation or
or custom installation and let me fire
up the custom installation just to tell
you all the areas that i actually
installed so this is the
oracle client and so I'm gonna run that
and so here it's going to ask if i want
to do a clean install or a custom
install after it after it comes up
there is ok there it is so you could do
on any of these are my just choose
custom and I go with the default
language to pick up on your whatever
your languages and then the you know
where you want to install it and then
I'm here so i saw i have installed the
oracle database utilities sequel plus
arm see the local net world connection
manager local odbc driver oracle sequel
developer so oracle sequel developer
that is the development tool you can use
to connect to on oracle and or objects
for only ODB ID okay the odbc to and
then I'm just to.net SP asp.net and I
think that's pretty much it
you're going to need to connect so
normally i would just go ahead and go
through this but i've already installed
is something to cancel out and then and
so let's just say that's installed you
probably want to do a reboot and then i
installed sequel developer notice the
tools i was telling you that you can
connect directly to oracle from and this
is real similar if you're familiar with
sequel server this is what you would use
to query the database on its way back I
mean sequel plus is terrible but this is
something that you can actually write
end it isn't a command prompt it's if
you're again if you're used to people
management studio this is something that
you can use to write queries and and
develop against the database so in here
you're going to want to once you fire
this up you're going to do a new
connection
and then you're going to want to put
whatever your connection name is and
then whatever your username and password
is to your oracle database and then here
you're going to want to put your
hostname and if its remote you're going
to want to put the IP address and let me
just open up the connection here that
already have established and so you can
see we put in our username a password
here and then the hostname which is a
remote database IP address the port
number the standard port number for
oracle 1521 and the CID which is XC
which i showed you which is it was in
the service name on as far as the
windows service and so here let me let
me get that password and put that in and
just show you how we can do a quick test
and so let's play set password in the
password them onto a test
ok so that shows us our connectivity to
the Oracle database from the from sequel
developer so let's just run a query here
make sure returns olds okay so we're
getting results now from that remote on
oracle database so now let's go into
sequel server and we want to be able to
query the oracle database from sequel
management studio so we need to create a
linked server and so a lot of times you
think servers to connect to other sequel
servers but in this case for in connect
to a oracle server so on
after you install the oracle client that
we produce went over you will see that
let's go to that you'll see that in the
providers there is now and oracle oracle
driver to be able to connect to that
oracle database so now you're going to
want to create a new link server and so
you can click on new linked server and
so I'm just going to edit the one that i
have created here and so for you can
give the linked server name
it's whatever name you want to give it
in this case I gave it oracle DB the
provider was oracle the Oracle um driver
that we installed with a client the
product name can be pretty much anything
you want and then the data source i
again i put in the server IP address
colon and the port which is 1521 and I
did not change anything else other than
security i change that be made using
this security context and then you put
in your oracle user name
password so now when you go in the
sequel management studio you can then
query the oracle database directly with
a query in school management studio and
so this is the Oracle linked server
oracle DB . and then the name in front
of the table so if i go into my tables
here and then the actual table name and
so this is the same way with sequel
server if you were to connect to a
different server you would you would put
in actual sequel server then the owner
of the database than the database and
the table name and so on in this case it
is the linked server