Collecting data from econda

Follow this guide to collect data from econda and preview the data.

Connecting to econda

Obtaining the econda REST URL

To access the econda API, follow these steps:

1. Request that the API services are enabled for your econda account. This step may include additional fees for your econda account.

2. In the econda user interface, create a report.

3. Follow the instructions in the econda documentation to generate a REST URL. For more information, see the econda documentation.

   An example of the REST URL for econda is shown below:

   https://monitor.econda-monitor.de/rest/chartservice?user=ABC&client=1234&pass=xxx&datascope=WEBANALYSIS&GENERATE_TYPE=CSV&CHAP1=bestellungen&fromDate=2018-01-01+00%3A00&toDate=2018-03-21+00%3A00

Adding econda as a Web Connect datastream

To add econda as a datastream, follow these steps:

1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

2. In the top right corner, click + Create datastream.

3. Search for and click Web Connect.

4. Click Next.

5. Select Continue without Connection, and then click Next.

6. Click Custom configuration.

7. In the URL field, paste the econda REST URL.

8. To add a date range to the data fetch, replace the date configuration at the end of the URL with the following placeholders:

   &fromDate={start} 00:00&toDate={end} 23:59:59

   The resulting URL:

   https://monitor.econda-monitor.de/rest/chartservice?user=ABC&client=1234&pass=xxx&datascope=WEBANALYSIS&GENERATE_TYPE=CSV&CHAP1=bestellungen&fromDate={start} 00:00&toDate={end} 23:59:59

9. In Request Method, select GET.

10. In Parser, select CSV (with semicolon delimiter).

11. In Encoding, select UTF-8.

12. Click Next.

Collecting initial data

To collect the initial data, follow these steps:

1. Choose the time period for which data is collected.

2. Click Run fetch.

Choosing where to load your data

To choose where to load your data, follow these steps:

1. To assign destinations to your datastream, select their checkboxes. For more information on destinations and their configuration settings, see Introduction to loading data into Adverity Data Storage and external destinations.

2. Click Next.

Previewing data collected from Connector Name

The fetch collects data from Connector Name which takes some time. The Overview page of the newly created datastream is now displayed. To preview the collected data, follow these steps:

1. In the All tasks tab, find the task at the top of the list, and click Show extracts.

2. Click the top hyperlink.

3. The data extract is displayed in a table containing the data that you have fetched.

What's next?

• Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.

• Transform your data to meet your needs by creating and applying enrichments to your datastream.

• Load your data into Adverity Data Storage to send it to BI tools using data shares

• Load your data into an external destination of your choice