oracle opens your windows dick vesters frank van der borden oracle nederland bv
DESCRIPTION
Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV. Agenda. Start installation of Oracle10 g DB SE Integration of Visual Studio and Oracle ?? Demo Oracle Enterprise Manager Integration of Windows and Oracle DB Summary. Installation Startup. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/1.jpg)
Oracle Opens Your Windows
Dick VestersFrank van der Borden
Oracle Nederland BV
![Page 2: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/2.jpg)
Agenda
• Start installation of Oracle10g DB SE• Integration of Visual Studio and Oracle ??• Demo Oracle Enterprise Manager• Integration of Windows and Oracle DB• Summary
![Page 3: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/3.jpg)
Installation Startup
![Page 4: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/4.jpg)
Oracle Developer Tools for Visual Studio .NET
![Page 5: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/5.jpg)
Oracle Developer Tools for Visual Studio .NET
• Tightly integrated “Add-in” for MS Visual Studio .NET
• Brings the power of Oracle Database to Windows developers
• Oracle is a premier-level partner in MS Visual Studio Industry Partner Program (VSIP)
• Beta2 now available www.oracle.com/technology/tech/dotnet/index.html
• Give feedback to [email protected]
![Page 6: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/6.jpg)
Develop on Windows, Database on any platform
Visual StudioEnvironment
Oracle Developer Oracle Developer Tools for VS.NETTools for VS.NET
Windows
Linux
Windows
Solaris
Oracle DB 10g, 9i
Other
![Page 7: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/7.jpg)
Feature Overview
• Oracle Explorer – browse / alter schema• Wizards & Designers – eg Table designer,
SP Wizard• Automatic Code Generation • Database Procedure PL/SQL Editor • Integrated Help System –SQL, PLSQL
keywords• .NET Stored Procedure Deployment
![Page 8: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/8.jpg)
Oracle Explorer
• Tree control, similar to “Server Explorer”• Can view most Oracle schema objects, not
just lowest common denominator• A starting place for most tasks
– View, Alter, Create schema objects– Auto generate code – View and edit Oracle data
![Page 9: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/9.jpg)
![Page 10: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/10.jpg)
Designers and Wizards
• Table Designer• View Designer• Stored Procedure/Function Wizard• Package Wizards• Sequence Designer• Synonym Designer• Data Adapter Wizard • .NET Stored Procedure Deployment Wizard
![Page 11: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/11.jpg)
![Page 12: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/12.jpg)
Data Window
• View and Update Table data• Run Stored procedures and view cursors
and arrays• Supports Oracle data types• View complex data types such as REF
Cursors
![Page 13: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/13.jpg)
![Page 14: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/14.jpg)
![Page 15: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/15.jpg)
PL/SQL Code Editor
• Syntax Coloring• Intelli-sense• Context sensitive help for SQL and PLSQL
Keywords and Datatypes• Intelligent Error display• Collapsible regions
![Page 16: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/16.jpg)
![Page 17: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/17.jpg)
![Page 18: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/18.jpg)
![Page 19: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/19.jpg)
![Page 20: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/20.jpg)
Automatic code generation
• Drag and drop a schema object from Oracle explorer
• Generated code uses Oracle Data Adapter (ODP.NET)
• Data Adapter Wizard can be run for custom designs
![Page 21: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/21.jpg)
![Page 22: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/22.jpg)
![Page 23: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/23.jpg)
![Page 24: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/24.jpg)
![Page 25: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/25.jpg)
Integrated Online Help
• Getting started• Walkthroughs• ODT Reference• Context sensitive help for UI elements• SQL Users Guide• PL/SQL Users Guide• Context sensitive SQL and PLSQL
keywords
![Page 26: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/26.jpg)
![Page 27: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/27.jpg)
Benefits• Easy to learn
– intuitive for Oracle on Windows programmers• Leverage MS Developers experience
– to write Oracle apps easily and quickly• Powerful features
– greatly enhance productivity – e.g.designers, code generation• Exposes native Oracle functionality and features
– not typically available in generic tools • Stay in your comfort zone
– You don’t have to leave your MS environment to do ordinary database tasks
![Page 28: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/28.jpg)
Agenda
• Start installation of Oracle10g DB SE• Integration of Visual Studio and Oracle ??• Demo Oracle Enterprise Manager• Integration of Windows and Oracle DB• Summary
![Page 29: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/29.jpg)
Oracle Enterprise Manager Demo
![Page 30: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/30.jpg)
Agenda
• Start installation of Oracle10g DB SE• Integration of Visual Studio and Oracle ??• Demo Oracle Enterprise Manager• Integration of Windows and Oracle DB• Summary
![Page 31: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/31.jpg)
ODP.NET - Basics• Available today in production for free
– www.oracle.com/technology/tech/dotnet/index.html– Original release: 2002– Fully compliant with ADO.Net
• Can be used with Oracle9i, Oracle10g DB servers– DB server can be on Windows, Linux, Unix, etc.– Database client on Windows
• Supports VS.NET 2002 and 2003• Supports .NET Framework 1.0 and 1.1• Wide adoption
– 50k+ ODP.NET downloads in past year– 4k+ posts on ODP discussion forum
![Page 32: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/32.jpg)
ODP.NET Object Model
DataSet OracleDataAdapter
OracleTransaction
OracleCommand
OracleConnection
OracleDataReader
Connected Layer(ODP.NET)
DisconnectedLayer
Oracle
OracleCommandBuilder
DataLayer
![Page 33: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/33.jpg)
ODP.NET Features
• Native Oracle data types– LOBs, REF Cursor, N-data types, Date,
TimeStamps, Long, Raw, etc.• Full DB procedure (PL/SQL) support
– Packaged, non-packaged, anonymous, autonomous
– Batch SQL available with anonymous PL/SQL• Grid Support (RAC)
– Notification callbacks
![Page 34: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/34.jpg)
Oracle XML DB
• XML repository• Native XMLType• XML stored as CLOB or object• Schema and non-schema-based• XML Views
![Page 35: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/35.jpg)
ODP.NET XML Features
• XMLType data type– Schema and non-schema based XML
• Query and Save XML from the DB– Both relational and object-relational
• Interoperate with .NET XML APIs – e.g. XmlReader, XmlDocument
• Supports XSLT and XPATH
![Page 36: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/36.jpg)
More ODP.NET Features• Connection Pooling
– Min, Max, Timeout, Lifetime, Increment, Decrement• Transactions
– Enterprise Services via Oracle Services for MTS– Local (Implicit and Explicit) – Save-points
• Globalization – Full Unicode support– Client settings are used to display Oracle data in
locale-specific manner
![Page 37: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/37.jpg)
ODP.NET Security
• Windows Native Authentication– Single sign-on
• Proxy user authentication– Connection pooling
• Full support of row level security in DB (VPD) and Oracle Label Security (OLS)
• Kerberos and SSL
![Page 38: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/38.jpg)
MSMS Data Access ProvidersData Access Providers OracleOracle
Native Access ( high performance ) Yes
Multiple Active Result Sets (MARS) Yes
Native XML Data Type Yes
Result Set Retrieval Tuning Options Yes
Configurable LOB Retrieval Yes
Array Parameters Yes
Security; Pooling; Globalization… Yes
Differences Oracle vs MS Data Access Provider
No
No
No
No
No
No
No
![Page 39: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/39.jpg)
New! ODP.NET 10.1.0.3
• Just released • SQL Statement Caching• Command cancellation and timeout • DeriveParameters support (automatic stored
procedure parameter metadata population) • Support for APIs introduced with ADO.NET 1.1 • And bug fixes...
![Page 40: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/40.jpg)
Agenda
• Start installation of Oracle10g DB SE• Integration of Visual Studio and Oracle ??• Demo Oracle Enterprise Manager• Integration of Windows and Oracle DB• Summary
![Page 41: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/41.jpg)
Summary
• Oracle brings the power of Oracle Database to Windows Developers
• Oracle is committed to delivering a great database for Windows and making Windows developers more productive when using Oracle Database
• dotNet Developer Centerwww.oracle.com/technology/tech/dotnet/index.html
![Page 42: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/42.jpg)
Dell Computer
• Uses ODP.NET to handle United States order management placed over the web
• Dell incorporates ODP.NET because– More control over connection pooling– Performance– Native support for ref cursors– Native support for LOB data types– Parameter binding
• Uses XML DB and ODP.NET for XML document manipulation
![Page 43: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/43.jpg)
AQ&Q U E S T I O N SQ U E S T I O N SA N S W E R SA N S W E R S
![Page 44: Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815fe9550346895dceed54/html5/thumbnails/44.jpg)