Databases
| Module | Type | Description |
|---|---|---|
Access | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializes a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
Btrieve | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
DB2 | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a Source for reading data records | |
InitializeTarget | Initializes a Target for saving data records | |
LookupRecord | Fetches a specific record from a Source | |
MapRecordFields | Setting the values of the specified DataFields in a target | |
SaveRecord | Saves the specified target record | |
EmbeddedDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Gets the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializes a connection for saving output data records. | |
LookupRecord | Gets a specific record from a data source | |
MapRecordFields | Maps values to specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
Firebird | CloseSource | The CloseFirebirdSource activity closes the specified source connection |
CloseTarget | The CloseFirebirdTarget activity closes the specified target connection | |
DeleteRecord | The DeleteFirebirdRecord activity deletes the specified target record | |
ExecuteStatements | The ExecuteFirebirdStatement activity is used to execute a custom sql statement on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | The GetNextFirebirdRecord activity fetches the next record from the specified source connection | |
InitializeSource | The InitializeFirebirdSource activity initializes a connection for reading data records at run time. Multiple InitializeFirebirdSource activites can be included in the workflow. | |
InitializeTarget | The InitializeFirebirdTarget is used for initializing a connection where output records will be saved. Multiple InitializeFirebirdTarget activites can be included in the workflow. | |
LookupRecord | The LookupFirebirdRecord activity fetches a specific record from a source connection | |
MapRecordFields | The MapAndSetFirebirdFields activity is used for setting the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
Informix | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
MariaDB | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
MySQL | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
Odbc | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Gets the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Loads a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
OleDb | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Gets the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
LookupRecord | Loads a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
Oracle | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
PostgreSQL | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
SqlAzure | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Gets the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Loads a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
SqlServer | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteSQLScript | Executes a SQL Server Script file | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Gets the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializes a connection for saving output data records. | |
LookupRecord | Gets a specific record from a data source | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
RunSSISPackage | Runs a SSIS package | |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) | |
SqlServerCe | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | The ExecuteSqlServerCeStatement activity is used to execute a custom sql statement on a connection | |
GetNextRecord | Gets the next record from the specified source connection | |
InitializeSource | Initializes a source for reading records at run time. | |
InitializeTarget | Initializes a connection where output records will be saved. | |
LookupRecord | Gets a specific record from a data source | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record - (Insert, Update, Upsert, Skipsert) | |
Sybase | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
Teradata | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
Vertica | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
ExecuteStoredProcedure | Executes a stored procedure on a data source. To utilize a stored procedure as a multi-record source, use the InitializeSource activity | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializes a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record | |
xBase | CloseSource | Closes the specified source connection |
CloseTarget | Closes the specified target connection | |
DeleteRecord | Deletes the specified target record | |
ExecuteStatements | Executes custom SQL statements on a connection | |
GetNextRecord | Fetches the next record from the specified source connection | |
InitializeSource | Initializes a connection for reading data records at run time. | |
InitializeTarget | Initializing a connection where output records will be saved. | |
LookupRecord | Fetches a specific record from a source connection | |
MapRecordFields | Sets the values of the specified DataFields in a target connection | |
SaveRecord | Saves the specified target record |
Last updated