InfoZoom Tips & Tricks – Part 6: Regular Pulling of Database Extracts to Update Reports

71 %
29 %
Information about InfoZoom Tips & Tricks – Part 6: Regular Pulling of Database Extracts to...
Business & Mgmt

Published on February 4, 2014

Author: corma

Source: slideshare.net

Description

Are you regularly facing the challenge to extract data from various data sources to use them for report updates?

InfoZoom Tips & Tricks – Part 6 Regular pulling of database extracts to update reports

About corma GmbH Stops suspects by: analytical investigations operative investigations Saves time by: online research online monitoring Increases efficiency and saves money by: data analytics global intelligence solutions 2

Workflow Step 1: • Establish a data source connection to the relevant databases in InfoZoom • Alternatively: Control panel – Administrative Tools – Set up data sources ODBC 3

Workflow Step 2: • Load the requested data from the data source into InfoZoom and create a template 4

Workflow Step 3: • Create a command line, which enables to reload the data in to the InfoZoom template: • Add the name of the generated InfoZoom file in to the command line, so that the file will be updated regularly by the reload function: 5

Workflow Hint regarding reloading data: • The command reload of data (“-load”) depends on the settings determined in the options for data import: • In case the InfoZoom file should be updated with the changed data from the data source, the mode “update” needs to be selected. • If the data from the data source should simple be added to the InfoZoom file without changing or updating the original data in the InfoZoom table, the mode “Append” needs to be selected 6

Workflow Optional report output: • • Excel report output via command line Hint: Predefined Excel report template is needed. 7

InfoZoom Trainings InfoZoom online trainings • IZ50 InfoZoom Web-Starter-Seminar • IZ51 InfoZoom Web-Expert-Seminar o Overview of all training dates can be found here: http://infozoom-onlinetraining.de/content/infozoom-online-trainingtrainings.html 8

Thank You! infozoom@corma.de +49 (2161) 277850 corma GmbH · Heinz-Nixdorf-Straße 22 · D-41179 Mönchengladbach · Tel: +49 2161 277 85 - 0 · E-Mail: mail@corma.de · Web: www.corma.de, www.blog.corma.de 9

Add a comment

Related presentations

Canvas Prints at Affordable Prices make you smile.Visit http://www.shopcanvasprint...

30 Días en Bici en Gijón organiza un recorrido por los comercios históricos de la ...

Con el fin de conocer mejor el rol que juega internet en el proceso de compra en E...

With three established projects across the country and seven more in the pipeline,...

Retailing is not a rocket science, neither it's walk-in-the-park. In this presenta...

What is research??

What is research??

April 2, 2014

Explanatory definitions of research in depth...

Related pages

InfoZoom Tips & Tricks – Part 5: Automated data ...

InfoZoom Tips & Tricks – Part 6: Regular pulling of database extracts to update reports ; ... Part 6: Regular pulling of database extracts to update ...
Read more

Access Tips: Access and SQL Part 6: Dynamic Reports

Part 6: Dynamic Reports; ... Update event procedure of each ... Access 97 or Access 2000 format. The database contains all five dialog boxes ...
Read more

Excel Magic Trick 538: Dynamic Sub Tables Based On Master ...

See how to create a 3 dimensional table set up like in a database program. Extract ... Excel Magic Trick 358: Part 1: ... Tips/Tricks For ...
Read more

Save a Still Image From Edit- GoPro Studio 2.0:GoPro Tips ...

... showing in great detail how to use every part of GoPro Studio 2 ... GoPro Studio 2.0:GoPro Tips and Tricks ... 6:56. by MicBergsma 87,956 ...
Read more