About dotConnect for Oracle
dotConnect for Oracle is a powerful database connectivity solution based on the ADO.NET architecture and a development framework with many options for developing database-related applications and websites. Such ORM solutions as Entity Framework and LINQ to SQL introduce innovative designing approaches and boost the database application development productivity.
Key Features
* Wide Coverage of Oracle Features
Access to the most advanced database functionality, lets the developers harness the full capabilities of the Oracle server and optimize the database applications. dotConnect for Oracle supports HA events from Oracle RAC, Oracle Transaction Guard, and Connection pool performance counters.
Flexible Connectivity
Two connection modes are supported for the Oracle server: connection through the Oracle Call Interface and direct connection over TCP/IP. Applications written with dotConnect for Oracle are easy to deploy, do not require installation of Oracle Client Software, and tend to be faster than those using other data connectivity solutions.
Optimized Code
The dotConnect for Oracle assemblies are implemented using optimized code and advanced data access algorithms.
Comprehensive Support for ADO.NET Technology Features
dotConnect for Oracle supports new ADO.NET features and technologies as soon as they are released.
Database Application Development Extensions
dotConnect for Oracle has convenient design-time component editors, wizards, and managers for typed Oracle-specific components, a toolset for live data binding, and much more. It integrates with Visual Studio 2008 / 2010 / 2012 / 2013 / 2015/ 2017 /2019, Visual Studio LightSwitch 2011 and 2012, Delphi, and SQL Server 2016 Business Intelligence Solutions.
Visual Studio 2022 support
dotConnect for Oracle version 10.0 grants full support for Visual Studio 2022 (version 17.2 and version 17.3 Preview). You can use all features of this Microsoft IDE.
Oracle Advanced Features Support
The solution supports Oracle-specific technologies. Particularly, OracleScript executes a series of SQL statements, OracleLoader loads external data into Oracle databases with the use of Direct Path API, OracleAlerter and OraclePipe transfer messages and data between connections or client applications, etc. There is a set of classes designed to work with Oracle Advanced Queuing technology.
Compatibility
Full support is provided for .NET Frameworks 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7, 4.8, .NET 5, .NET 6 and .NET Compact Framework. Also, dotConnect for Oracle supports Mono version 2.0 and above. The product is compatible with ADO.NET Entity Framework v1 - v6.4 and Entity Framework Core 1.1, 2.2, 3.1, and 5. Since version 10.0, it also supports .NET 6 and providers full Visual Studio 2022 support. (Oracle server 9.2.0.4 or higher is required for Entity Framework). Additionally, dotConnect for Oracle provides .NET Standard 1.3 compatible assemblies, which are compatible with .NET Core 1.x, 2.x and 3.0, NET Framework 4.6 and higher, and .NET Standard 2.0. Also, the assemblies are compatible with .NET Core 2.0 and higher and .NET Framework 4.6.1 and higher.
ADO.NET Entity Framework Support
dotConnect for Oracle supports all the Entity Framework versions - Entity Framework v1, v4, v5, and v6 and Entity Framework Core 1.1, 2.2, 3.1, 5.0, and 6.0.
LinqConnect
The support for LINQ to Oracle technology allows you to develop object-oriented database applications much faster and easier.
Connected and Disconnected Models
dotConnect for Oracle combines connected and disconnected data access models in a single OracleDataTable component. It allows for designing a more flexible application architecture with the full power of data binding.
BIS Support
You can use the provider in SQL Server Business Intelligence Solution (BIS) projects. It offers native Devart Oracle Source and Devart Oracle Destination components for Data Flows in Integration Services projects. Also, it supports Reporting Services and Analysis Services projects, including SQL Server 2016 Business Intelligence.
Development Environments
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2013
Visual Studio 2012
Visual Studio 2010
Visual Studio 2008
Security
OS authentication (NTLM)
Proxy Authentication support
Oracle Data Encryption
Oracle Data Integrity
Support for encryption algorithms: RC4, RC4-56, RC4-128, RC4-256, DES-40, DES-56, DES-112, DES-168, AES-128, AES-192, AES-256
Support for checksum algorithms: MD5, SHA1, SHA256, SHA384, SHA512
Full support for operation in the FIPS 140-2 mode in Windows
SSL/TLS encryption support
SSH encryption support
Passing credentials via OracleCredential class, based on SecureString
|
About IBM Cloudant
Cloudant is an IBM software product, delivered as a cloud-based service, based on the Apache-backed CouchDB project and the open source BigCouch project.
IBM Cloudant is a fully managed JSON document store for progressive web and mobile applications that maintain data access, optimized for data availability, durability, and mobility. It is integrated data management, search, and analytics engine designed for web applications.
This service is being used across the organization for big data analytics, amongst other things for text analytics as it permits unlimited index fields. It is an operational
data store, for storing and indexing JSON documents, and can handle concurrent reads & writes.
|
FAQs
No FAQs associated with this application.
|
FAQs
Does this service offer guides, tutorials and or customer support?
-
Email support, FAQ, Knowledge base, Video Tutorials, Webinar
What is this service generally used for?
-
As a noSQL database across the organization for big data analytics.
What are some applications this service is commonly used in tandem with?
-
DB2
Does this service offer an API?
-
Yes, it offers RESTful API
Does this service integrate with any other apps?
-
It integrates with various apps, like: Watson Virtual Agent, IBM Service Discovery, Chef Watson, IBM Bluemix OpenWhisk, IBM Event Ledger, Vehicle Data Hub, and more.
What platforms does this service support?
-
Cloud-based
Does this service offer multi-user capability (e.g. teams)?
-
Yes
Who are the main user groups of this service?
-
Cloudant is being used by big enterprises. It is best suited for highly scalable environments as it comes with data base as a service.
|