Solved

Visio diagram to document database download, upload, excel file ftp

Posted on 2013-11-07
2
1,757 Views
Last Modified: 2013-11-12
Not that experienced using Visio

Looking to create a Visio document  that depicts a process that does the following

1.  Retrieve data from tables in several data bases  (via a sql view)

2.  Insert the retrieved data into a different database

3. create an Excel file extract

4. Ftp the Excel file to an ftp server


I know there is a database shape and an Excel spreadsheet shape but struggling with the best combination of other shapes to document this.  Doesn't seem like an uncommon process

I have spent some time trying to google search for examples but so far haven't found anything

Anybody have a sample I could look at for ideas?
0
Comment
Question by:johnnyg123
2 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
Comment Utility
The simplest solution is probably just to draw a flowchart. Start with the Basic Flowchart template, which is located in the Flowchart template category. Then use the Process shape for the steps and the External Data shape to represent the data stores. Not fancy but it gets the message across. Something like this:sample
0
 

Author Closing Comment

by:johnnyg123
Comment Utility
Great idea ...I think I was trying to make it harder than it was
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now