tyruss8
asked on
MS SQL Server Management Studio R2
I have a ms sql server management studio r2 at work, and was if I can do the following below?
1) Can I connect to an Oracle database warehouse, and create queries from this tool? Example, from an Access db, I connect to our oracle data warehouse though ODBC connection. Is this also possible?
2) This might be a dumb question but can I use this tool like how I would use MS Access? In terms of linking in and connecting to tables, excel tables. And then create queries and tables to manipulate data?
Thanks
1) Can I connect to an Oracle database warehouse, and create queries from this tool? Example, from an Access db, I connect to our oracle data warehouse though ODBC connection. Is this also possible?
2) This might be a dumb question but can I use this tool like how I would use MS Access? In terms of linking in and connecting to tables, excel tables. And then create queries and tables to manipulate data?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
you need to install some Oracle Client Tools
then add a linked server before use it
https://www.sqlshack.com/link-sql-server-oracle-database/