Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article outlines how to use the copy activity in a pipeline to copy data from and to Microsoft Access.
Supported configuration
For the configuration of each tab under copy activity, go to the following sections respectively.
General
Refer to the General settings guidance to configure the General settings tab.
Source
The following properties are supported for Microsoft Access under the Source tab of a copy activity.
The following properties are required:
Connection: Select a Microsoft Access connection from the connection list. If no connection exists, then create a new Microsoft Access connection.
Use query: Select Table or Query.
If you select Table:
- Table: Specify the name of the table in the Microsoft Access to read data.
If you select Query:
Query: Specify the custom SQL query to read data.
Under Advanced, you can specify the following fields:
- Additional columns: Add additional data columns to store source files' relative path or static value. Expression is supported for the latter.
Destination
The following properties are supported for Microsoft Access under the Destination tab of a copy activity.
The following properties are required:
Connection: Select a Microsoft Access connection from the connection list. If no connection exists, then create a new Microsoft Access connection.
Table: Specify the name of the table in the Microsoft Access to write data.
Under Advanced, you can specify the following fields:
Pre-copy script: Specify a SQL query for Copy Activity to execute before writing data into data store in each run. You can use this property to clean up the pre-loaded data.
Write batch timeout: Specify the wait time for the batch insert operation to complete before it times out. The allowed value is timespan. The default value is "00:30:00" (30 minutes).
Write batch size: Inserts data into the SQL table when the buffer size reaches writeBatchSize. The allowed value is integer (number of rows). The default value is 0 - auto detected.
Max concurrent connections: Specify the upper limit of concurrent connections established to the data store during the activity run. Specify a value only when you want to limit concurrent connections.
Mapping
For Mapping tab configuration, go to Configure your mappings under mapping tab.
Settings
For Settings tab configuration, see Configure your other settings under settings tab.
Table summary
The following tables contain more information about the copy activity in Microsoft Access.
Source information
| Name | Description | Value | Required | JSON script property |
|---|---|---|---|---|
| Connection | Your connection to the source data store. | <your Microsoft Access connection> | Yes | connection |
| Use query | The way to read data from Teradata. Apply Table to read data from the specified table or apply Query to read data using queries. | • Table • Query |
No | / |
| For Table | ||||
| Table | Your source data table to read data. | < your table name > | No | tableName |
| For Query | ||||
| Query | Use the custom SQL query to read data. | < SQL queries > | No | query |
| Additional columns | Add additional data columns to store source files' relative path or static value. Expression is supported for the latter. | • Name • Value |
No | additionalColumns: • name • value |
Destination information
| Name | Description | Value | Required | JSON script property |
|---|---|---|---|---|
| Connection | Your connection to the destination data store. | < your Teradata connection > | Yes | connection |
| Table | Your destination data table to write data. | < your table name > | Yes | tableName |
| Pre-copy script | Specify a SQL query for Copy Activity to execute before writing data into data store in each run. You can use this property to clean up the pre-loaded data. | < your pre-copy script > | No | preCopyScript |
| Write batch timeout | The wait time for the batch insert operation to finish before it times out. | timespan (the default is 00:30:00 - 30 minutes) |
No | writeBatchTimeout |
| Write batch size | Inserts data into the SQL table when the buffer size reaches writeBatchSize. | <number of rows> (integer) |
No | writeBatchSize |
| Max concurrent connections | The upper limit of concurrent connections established to the data store during the activity run. Specify a value only when you want to limit concurrent connections. | <upper limit of concurrent connections> (integer) |
No | maxConcurrentConnections |