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:
-
Request that the API services are enabled for your econda account. This step may include additional fees for your econda account.
-
In the econda user interface, create a report.
-
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:
-
Go to the Datastreams page.
-
In the top right corner, click + Create datastream.
-
Search for and click Web Connect.
-
Click Next.
-
Select Continue without Connection, and then click Next.
-
Click Custom configuration.
-
In the URL field, paste the econda REST URL.
-
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
-
In Request Method, select GET.
-
In Parser, select CSV (with semicolon delimiter).
-
In Encoding, select UTF-8.
-
Click Next.
Collecting initial data
To collect the initial data, follow these steps:
-
Choose the time period for which data is collected.
-
Click Run fetch.
Choosing where to load your data
To choose where to load your data, follow these steps:
-
To assign destinations to your datastream, select their checkboxes. For more information on destinations and their configuration settings, see Loading data into destinations.
-
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:
-
In the All tasks tab, find the task at the top of the list, and click Show extracts.
-
Click the top hyperlink.
-
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 Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice