Class SQLImportConfigurationSpec
java.lang.Object
com.orchestranetworks.addon.dex.configuration.SQLImportConfigurationSpec
- All Implemented Interfaces:
ConfigurationSpec<SQLTable>
,ImportConfigurationSpec<SQLTable>
public final class SQLImportConfigurationSpec
extends Object
implements ImportConfigurationSpec<SQLTable>
Defines the configuration used for importing data from an external database.
- Since:
- 2.3.0
-
Constructor Summary
ConstructorsConstructorDescriptionSQLImportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session) Imports data with a filter andJNDIDataSource
outside of aUIService
.SQLImportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) Imports data withJNDIDataSource
outside of aUIService
.SQLImportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session) Imports data from an SQL table with a filter outside of aUIService
.SQLImportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) Imports data outside of aUIService
. -
Method Summary
Modifier and TypeMethodDescriptioncom.onwbp.adaptation.Adaptation
Returns the current dataset.com.onwbp.adaptation.AdaptationTable
Returns the current table.Returns the map of theFieldMapperDefinition
implementations andTableMapping
instance as the key parameter.Returns the specified import mode.Returns the specified JNDI data source for SQL import.Returns the specified schema name.Returns the service type.com.orchestranetworks.service.Session
Returns the current session.Returns a map of table filters and anSQLTable
instance as the key parameter.Returns the list of source tables.Returns the SQL data source name.Returns the specified table naming pattern.boolean
Returnstrue
if all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed.boolean
Returnstrue
if all empty ornull
values are ignored in the process of importing data.boolean
Returnstrue
if all triggers and constraints are disabled in the process of importing data.void
setEmptyOrNullPrimaryKeyChecked
(boolean emptyOrNullPrimaryKeyChecked) Sets whether all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed.void
setEmptyOrNullValueIgnored
(boolean emptyOrNullValueIgnored) Sets whether all empty ornull
values are ignored in the process of importing data.void
setFieldMapperDefinitions
(Map<TableMapping, FieldMapperDefinition> fieldMapperDefinitions) Sets a map of theFieldMapperDefinition
implementations andTableMapping
instance as the key parameter.void
setImportForced
(boolean importForced) Sets whether all triggers and constraints are disabled in the process of importing data.void
setImportMode
(ImportMode importMode) Sets the import mode.void
setTablePattern
(String tablePattern) Sets a table naming pattern.
-
Constructor Details
-
SQLImportConfigurationSpec
public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) throws DataExchangeException Imports data outside of aUIService
.- Throws:
DataExchangeException
-
SQLImportConfigurationSpec
public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) throws DataExchangeException Imports data withJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
SQLImportConfigurationSpec
public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session) throws DataExchangeException Imports data from an SQL table with a filter outside of aUIService
.- Throws:
DataExchangeException
-
SQLImportConfigurationSpec
public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session) throws DataExchangeException Imports data with a filter andJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
-
Method Details
-
getServiceType
Returns the service type.- Specified by:
getServiceType
in interfaceConfigurationSpec<SQLTable>
-
isImportForced
public boolean isImportForced()Returnstrue
if all triggers and constraints are disabled in the process of importing data.- Specified by:
isImportForced
in interfaceImportConfigurationSpec<SQLTable>
-
setImportForced
public void setImportForced(boolean importForced) Sets whether all triggers and constraints are disabled in the process of importing data. -
getImportMode
Returns the specified import mode.- Specified by:
getImportMode
in interfaceImportConfigurationSpec<SQLTable>
-
setImportMode
Sets the import mode. -
isEmptyOrNullValueIgnored
public boolean isEmptyOrNullValueIgnored()Returnstrue
if all empty ornull
values are ignored in the process of importing data.- Specified by:
isEmptyOrNullValueIgnored
in interfaceImportConfigurationSpec<SQLTable>
-
setEmptyOrNullValueIgnored
public void setEmptyOrNullValueIgnored(boolean emptyOrNullValueIgnored) Sets whether all empty ornull
values are ignored in the process of importing data. -
isEmptyOrNullPrimaryKeyChecked
public boolean isEmptyOrNullPrimaryKeyChecked()Returnstrue
if all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed.- Specified by:
isEmptyOrNullPrimaryKeyChecked
in interfaceImportConfigurationSpec<SQLTable>
-
setEmptyOrNullPrimaryKeyChecked
public void setEmptyOrNullPrimaryKeyChecked(boolean emptyOrNullPrimaryKeyChecked) Sets whether all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed. -
getSQLDataSourceName
Returns the SQL data source name. -
getCurrentDataset
public com.onwbp.adaptation.Adaptation getCurrentDataset()Returns the current dataset.- Specified by:
getCurrentDataset
in interfaceConfigurationSpec<SQLTable>
-
getCurrentTable
public com.onwbp.adaptation.AdaptationTable getCurrentTable()Returns the current table.- Specified by:
getCurrentTable
in interfaceConfigurationSpec<SQLTable>
-
getSession
public com.orchestranetworks.service.Session getSession()Returns the current session.- Specified by:
getSession
in interfaceConfigurationSpec<SQLTable>
-
getSourceTables
Returns the list of source tables.- Specified by:
getSourceTables
in interfaceConfigurationSpec<SQLTable>
-
getSourceTableFilters
Returns a map of table filters and anSQLTable
instance as the key parameter. Returnsnull
when importing CSV, Excel and XML.- Specified by:
getSourceTableFilters
in interfaceConfigurationSpec<SQLTable>
-
getFieldMapperDefinitions
Returns the map of theFieldMapperDefinition
implementations andTableMapping
instance as the key parameter. -
setFieldMapperDefinitions
public void setFieldMapperDefinitions(Map<TableMapping, FieldMapperDefinition> fieldMapperDefinitions) Sets a map of theFieldMapperDefinition
implementations andTableMapping
instance as the key parameter. -
getTablePattern
Returns the specified table naming pattern. -
setTablePattern
Sets a table naming pattern. -
getSchemaName
Returns the specified schema name. -
getJNDIDataSource
Returns the specified JNDI data source for SQL import.- Since:
- 2.5.0
-