1 / 44

Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV

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.

opa
Download Presentation

Oracle Opens Your Windows Dick Vesters Frank van der Borden Oracle Nederland BV

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Opens Your WindowsDick VestersFrank van der BordenOracle Nederland BV

  2. Agenda • Start installation of Oracle10g DB SE • Integration of Visual Studio and Oracle ?? • Demo Oracle Enterprise Manager • Integration of Windows and Oracle DB • Summary

  3. Installation Startup

  4. Oracle Developer Tools for Visual Studio .NET

  5. 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 christian.shay@oracle.com

  6. Develop on Windows, Database on any platform Oracle Developer Tools for VS.NET Linux Windows Visual Studio Environment Solaris Windows Other Oracle DB 10g, 9i

  7. 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

  8. 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

  9. 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

  10. 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

  11. PL/SQL Code Editor • Syntax Coloring • Intelli-sense • Context sensitive help for SQL and PLSQL Keywords and Datatypes • Intelligent Error display • Collapsible regions

  12. 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

  13. 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

  14. 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

  15. Agenda • Start installation of Oracle10g DB SE • Integration of Visual Studio and Oracle ?? • Demo Oracle Enterprise Manager • Integration of Windows and Oracle DB • Summary

  16. Oracle Enterprise Manager Demo

  17. Agenda • Start installation of Oracle10g DB SE • Integration of Visual Studio and Oracle ?? • Demo Oracle Enterprise Manager • Integration of Windows and Oracle DB • Summary

  18. 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

  19. ODP.NET Object Model Disconnected Layer Connected Layer (ODP.NET) Data Layer Oracle DataAdapter OracleCommand Builder DataSet Oracle DataReader Oracle Command Oracle Transaction Oracle Connection Oracle

  20. 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

  21. Oracle XML DB • XML repository • Native XMLType • XML stored as CLOB or object • Schema and non-schema-based • XML Views

  22. 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

  23. 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

  24. 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

  25. Differences Oracle vs MS Data Access Provider MS Data Access Providers Oracle 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 No No No No No No No

  26. 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...

  27. Agenda • Start installation of Oracle10g DB SE • Integration of Visual Studio and Oracle ?? • Demo Oracle Enterprise Manager • Integration of Windows and Oracle DB • Summary

  28. 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

  29. 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

  30. Q & Q U E S T I O N S A N S W E R S A

More Related