# 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 | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.appstrategy.com/apprules-r-documentation/platform/platform-features/actions/action-categories/actions-datasource/databases.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.