ETLBox ETLBox ETLBox Buy
API
Try Buy

HanaOdbcConnectionManager

Class HanaOdbcConnectionManager

SAP HANA Connection manager for an ODBC connection based on ADO.NET. ODBC by default does not support a Bulk Insert - inserting big amounts of data is translated into a

insert into (...) values (..),(..),(..) statements.

This means that inserting big amounts of data in a database via Odbc can be much slower than using the native connector. Also be careful with the batch size - some databases have limitations regarding the length of sql statements. Reduce the batch size if you encounter issues here.

Inheritance
object
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>
OdbcConnectionManager
HanaOdbcConnectionManager
Implements
Inherited Members
Namespace: ETLBox.Odbc
Assembly: ETLBox.Odbc.dll
Syntax
    public class HanaOdbcConnectionManager : OdbcConnectionManager, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposable

Constructors

HanaOdbcConnectionManager()

Declaration
    public HanaOdbcConnectionManager()

HanaOdbcConnectionManager(OdbcConnectionString)

Declaration
    public HanaOdbcConnectionManager(OdbcConnectionString connectionString)
Parameters
TypeNameDescription
OdbcConnectionStringconnectionString

HanaOdbcConnectionManager(string)

Declaration
    public HanaOdbcConnectionManager(string connectionString)
Parameters
TypeNameDescription
stringconnectionString

Methods

Clone()

Cretes a clone of the current connection manager

Declaration
    public override IConnectionManager Clone()
Returns
TypeDescription
IConnectionManager

A instance copy of the current connection manager

Overrides

Implements