?
Solved

Map Point Live Data Source

Posted on 2013-05-24
5
Medium Priority
?
300 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 1500 total points
ID: 39204873
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

800 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