UniversalTemplate/logo.png UniversalTemplate/UTS.png

Moving Data From One Database to Another With Argos.

1. Create a data block with a report query of the data you want to move from first database like this:

Argos_report_query.png

2. Create a new Extract text report like this:

Argos_extract_text_report.png

3. Click on Design button and then change the Report Format to Delimited. Put the type of delimiter you are using in the box next to the work Delimiter like this:

Argos_configure_extract_delimited_report.png

4. Add Detail under Report Options by clicking on + plus sign under Report Structure. On the right click on the Fields tab and add the fields from your report query like this:

Argos_detail.png

5. Add a dataset by clicking on + plus sign below Datasets on right. In the pop-up window put name of dataset, name of Master Dataset. Insert code into SQL box. Pick your Connection which should be database where data is going to like this:

Argos_create_dataset_for_inserting.png

6. Validate report and save. Run dashboard. Pick report from Report Options and hit save. This will run report and insert data into database of your choice.