To export data to cloud databases

 

Note: If you have already added a cloud database connection, you can simply select the existing connection under the Saved connections section and proceed with exporting.

1. If the new rows are to be added to the table, choose Append.
2. If the newly added rows are to replace the existing rows, select Overwrite from the dropdown.

Note: Target matching failure is not an export failure. Target matching happens before the data is actually exported to the destination. This way the schema or data model errors that could cause export to fail are caught beforehand preventing export failures. Learn more about target matching.

When target match check fails

Pro Tip: The default view shows only the error columns, but you can always uncheck the Show only error checkbox to view all the columns.

The errors in target matching are explained below:

1. Unmatched columns : This option shows all the unmatched columns in the source and target datasets.
   
   
   
   

   Note:
   

   1. The non-mandatory columns in the target can either be matched with a source column if available or ignored.
   2. The columns in the source that are missing in the target need to be matched or removed to proceed exporting. 

    
   
   
   
   

   When using the unmatched columns option, you can toggle the Show only mandatory columns option to see if there are any mandatory columns(set as mandatory in the target) and include them. You can also fix only the mandatory columns and proceed to exporting.
   

   
   

   
   

   
   

1. Data type mismatch : This option displays the columns from the source dataset having data types that do not match the columns in the target.
2. Data format mismatch : This option displays columns from the source dataset having date, datetime and time formats that differ from those in the target dataset.
3. Constraint mismatch : This option displays the columns that do not match the data type constraints of the columns in the target. To know how to add constraints for a column, click here.
4. Mandatory column mismatch: This option displays the columns that are set as mandatory in the target but not set as mandatory in your source dataset.
   
   
   

   Note: The mandatory columns cannot be exported to the destination unless they are matched and set as mandatory. You can click the  icon above the column to set it as mandatory. You can also use the Set as mandatory (not null) check box under the Change data type transform to set a column as mandatory.
5. Data size overflow warnings : This option filters the columns with data exceeding the maximum size allowed in the target.

Note: The Data size overflow warning is only applicable to database targets.

1. The Target match errors section shows the errors and the number of columns associated with each error. 
2. The section at the top lists the error categories along with the number of errors in each category.
3. You can click them to filter errors related to each category in the panel.
4. In the default view, all columns are displayed. However, you can click any error category and get a closer look at the columns or view the error columns alone by selecting the Show only errors checkbox. 
5. Your filter selection in the Target match errors panel will also be applied on the grid in the DataPrep Studio page. 
   

4. After fixing the errors you can proceed with exporting your data to cloud database.

6. You can also choose to schedule the export using the Schedule this export? option.

 

1. Select a Repeat method (Every 'N' hours, Every day, Weekly once, Monthly once) and set frequency using Perform every dropdown.

1. You can also select the Time zone to export data. By default, your local timezone will be selected and click Save.