# 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 |