Solved

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

Posted on 2013-11-07
2
1,817 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
ID: 39635180
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
ID: 39642368
Great idea ...I think I was trying to make it harder than it was
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Generating a graph via Excel 3 38
Microsoft Edge, Outlook OWA 7 50
stuck in average 16 47
Question about Relationship and Userform in Access Database 17 54
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.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

773 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