Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-11-07
2
Medium Priority
?
2,121 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 31

Accepted Solution

by:
Scott Helmers earned 2000 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

571 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