ETLBox
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
HanaOdbcConnectionManager
Inherited Members
Namespace: ETLBox.Odbc
Assembly: ETLBox.Odbc.dll
Syntax
public class HanaOdbcConnectionManager : OdbcConnectionManager, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposableConstructors
HanaOdbcConnectionManager()
Declaration
public HanaOdbcConnectionManager()HanaOdbcConnectionManager(OdbcConnectionString)
Declaration
public HanaOdbcConnectionManager(OdbcConnectionString connectionString)Parameters
| Type | Name | Description |
|---|---|---|
| OdbcConnectionString | connectionString |
HanaOdbcConnectionManager(string)
Declaration
public HanaOdbcConnectionManager(string connectionString)Parameters
| Type | Name | Description |
|---|---|---|
| string | connectionString |
Methods
Clone()
Cretes a clone of the current connection manager
Declaration
public override IConnectionManager Clone()Returns
| Type | Description |
|---|---|
| IConnectionManager | A instance copy of the current connection manager |