community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Maveryx Success Stories

Learn how Alteryx customers transform their organizations using data and analytics.
STORIES WANTED

Showcase your achievements in the Maveryx Community by submitting a Success Story now!

SUBMISSION INSTRUCTIONS

Compensar Uses Designer to Create and Push XML Files

AlteryxAdvocacy
Alteryx
Alteryx
‎04-23-2019 08:38 AM
itPerforma.jpgCompensar.jpg

Overview of Use Case

Compensar is a Colombian private social security entity whose purpose is the development of families, workers, and companies. They are using Alteryx for data prep and blend and predictive analytics in their financial services, planning, and corporate management departments. Learn in this use case how Compensar is using Alteryx Designer to create XML files to update web services.

 
Describe the business challenge or problem you needed to solve
The business challenge was to verify that all the information being processed and going to the web service is correct.
 
Describe your working solution
Together with iTPerforma, an Alteryx partner in Colombia, Compensar’s team created several workflows to get tags in an XML file and push it to the web service.
  • Build a workflow that blends different data sources (EPS, Kactus, Orbita) that serves as input to the XML file
  • Modify the 7 Business information management workflows
  • Adjust and tests the workflows 
  • Create a macro that also saves the files in the local server in case the web call fails
  • Create a workflow that moves the processed files to another folder

We created different workflows that collect information from the Kactus and Orbita databases and generated files in XML format to send to the web service.

 

Workflow CreacionXML.ywmc: this workflow builds the XML files that are sent to the web service.

  Flujograma LlamarWS_Creacion.png

Workflow LlamarMacroWS.yxmd: this workflow brings the data that come from different database (EPS, Kactus, Orbita) and connect to the macro to verify line byline.

 

 Flujograma LlamarMacro.png

 

Workflow Moverarchivos.yxmd: We run this workflow after the macro. It validates the files in case the web call fails, and it moves the processed files to a folder.

  

 Flujograma MoverArchivos.png

 

Workflow CargaOrbita&Kactus.yxmd: This workflow is connected to Orbita and Kactus’ databases to bring the user's data. With these data, the corresponding files are created for the input of the LlamarMacroWS workflow.

 

Flujograma CargaOrbita&Kactus.png

 

 

 
Describe the benefits you have achieved
 Alteryx workflows allowed us to collect and verify the information we needed. In addition, the macro allows us to create backup files in case something happens and we lose connection to the web calls.

 

Related Resources
 
 

 

0 Likes
Labels