Map Point Live Data Source

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
BananaFuryAsked:
Who is Participating?
 
Simon BallCommented:
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
 
BananaFuryAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.