Solved

Map Point Live Data Source

Posted on 2013-05-24
5
290 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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
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…

733 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