MapInfo Pro

Expand all | Collapse all

Replacement for DBMS Catalog tool

  • 1.  Replacement for DBMS Catalog tool

    Posted 14 days ago
    Hello the DBMS Catalog tool was removed from 64bit MapInfo. We have been told by support to use "easy loader", however there is no button to create a Map Catalog here. There are options to edit and existing map catalog, or to upload NEW tables and data, and create a map catalog.

    If I have an existing spatial database, and wish to create a map catalog (to so you can then use TABLE>database>Make DBMS table mappable), how can we achieve this from a MapInfo UI option?
    We do not want users to have to learn SQL and remote into a database, when all they are trying to do is have MapInfo import existing spatial database point data, that other software can handle without DB modifications.

    ------------------------------
    Joshua Knight
    Datamine

    ------------------------------


  • 2.  RE: Replacement for DBMS Catalog tool

    Pitney Bowes
    Posted 14 days ago
    Hi Joshua.

    Yes, you can use MapinfoEasyLoader to create the MapCatalog on the DBMS, if one doesn't exist.
    This occurs as part of initializing the MapCatalog display in MapInfoEasyLoader, so to create one, you just open the "Map Catalog" from the main panel.

    It does require a MAPINFO user (pwd: MAPINFO) with the appropriate table creation privileges on the server.
    It is, admittedly, not intuitive, nor did we update the documentation appropriately to describe the behavior.

    Please let us know if you have further issues.

    Regards,
    -john

    ------------------------------
    John Teague
    PITNEY BOWES SOFTWARE, INC
    Troy NY
    ------------------------------



  • 3.  RE: Replacement for DBMS Catalog tool

    Posted 14 days ago
    Thanks that works.

    ------------------------------
    Joshua Knight
    Datamine
    Kew
    ------------------------------



  • 4.  RE: Replacement for DBMS Catalog tool

    Pitney Bowes
    Posted 13 days ago
      |   view attached
    Hi Josh.
    Latest updates for Database samples.  MIODBCAT tool will work for Access DB's, but the tool code was never updated for support of later databases such as SQL Server, SQLite, and PostGIS as it was completely replaced by EasyLoader tool for creating Map_Catalogs.  It used to be only for Access, Oracle XY, Sybase, and DB2.  It was really OLD (circa mid 90's) and also only for Win32 and Win16 arch.  Code attached here has been updated enough so that it will work within x64 architecture and load into the Ribbon interface. If you want to add support for creating MapCatalogs in other db's, please modify as you wish.
    These will be provided in next MB release installer as well.  Please share your updates to it.

    Cheers,
    -Bill

    ------------------------------
    Bill Wemple
    Principal QA Engineer
    Pitney Bowes
    Troy, NY
    ------------------------------

    Attachment(s)

    zip
    DATABASE.zip   152K 1 version