Database connections and import templates are created in Metrics Management and typically do not require the assistance of a DBA or of IT resources. To enable importing to and exporting from an Access database, first create a data connection to an Access database. Then, create and configure a Metrics Management import or export that uses that connection.
You may need to talk with your Access database administrator to ensure that the proper queries are configured and that you know where the resulting data is going to be stored, for example in a stored procedure, table, view, or direct SQL code in Metrics Management. Before importing data from an Access database, ensure that:
Tables or queries include the data you wish to import.
The column structure in Access matches the column import structure specified in Metrics Management.
Before exporting data to an Access database, ensure that:
The Access database contains a table formatted to handle the output from Metrics Management.
The column structures in Access are in the same order and are of the same type as those defined in Metrics Management.
Tables or queries include the data you wish to import.