Solved

Map Point Live Data Source

Posted on 2013-05-24
5
294 Views
Last Modified: 2013-06-04
HI,

I have a copy of Map Point. I am trying to feed it data from our SQL MS datawarehouse direct, as apposed to the current school boy approach of extracting data into a .csv, and importing this .csv into the map tool, and updating it whenever the data changes.

ps I suspect this question isn't in the correct section, but I wasn't too sure where to place it

Thanks
0
Comment
Question by:BananaFury
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 15

Expert Comment

by:Simon Ball
ID: 39203809
is it this package:

https://www.youtube.com/watch?v=m2oRMGHqe90

It says in the video that it can only import from excel and access db's... doesn't mention ODBC to sql server.

It looks like it could be done by exporting sql data using dts/ssis ( depending on your sql server version) into excel or access format, and having map point connect to that exported file.
0
 

Author Comment

by:BananaFury
ID: 39203985
I have a way around this now, providing MS Access with a view of a live table, and feeding MapPoint with the content of this Access container, but I cannot imagine this is the correct approach to the problem (as suggested by Sudonim I note)

I have been nudged towards using a Mappoint API to drop data straight in from a SQL postcode dump. Does this mean anything to anybody?
0
 
LVL 15

Accepted Solution

by:
Simon Ball earned 500 total points
ID: 39204873
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

728 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