Spectrum Technology Platform

  • 1.  How do you connect SSA to T1 or another database server?

    Posted 10-25-2021 20:47
    Greetings;

    What is the best method connecting SSA to T1 or another database server?

    ------------------------------
    Ayman Hamzeh
    Spatial Analyst
    Sydney Spatial Services
    Sydney NSW
    ------------------------------


  • 2.  RE: How do you connect SSA to T1 or another database server?

    Posted 10-26-2021 16:14
    Edited by Matt Smith 10-26-2021 16:14
    Hi Ayman,

    I'm assuming by T1 you mean technology one?
    Spectrum Spatial offer JDBC connections if needed to connect to data at the database level. Application to Application integration is also possible via the generic link framework which allows you to link in both directions from a third party application.

    Feel free to email me if you need further information
    matt.smith@spatialdistillery.com

    ------------------------------
    Matt Smith
    The Spatial Distillery
    Sydney NSW
    ------------------------------



  • 3.  RE: How do you connect SSA to T1 or another database server?

    Posted 10-26-2021 18:43
    Hi Matt;

    Yes T1 is Technology One. What you're saying is very good start for me.
    May I get the generic link framework to start with?

    Thank you.

    ------------------------------
    Ayman Hamzeh
    Spatial Analyst
    Sydney Spatial Services
    Sydney NSW
    ------------------------------



  • 4.  RE: How do you connect SSA to T1 or another database server?

    Posted 10-27-2021 19:18
    Hi Ayman,

    To carry out two-way dynamic linking to Tech One products (where selected records in SSA are displayed in the Tech One front end) it is worth checking that the Tech One API is available at your site.  There are other options but these may require some manual steps.  At the SSA end you will need Applinking enabled.  A 3rd-party middleware product can then be used to carry out the actual link.

    ------------------------------
    James Nolet
    Dooley Mitchell & Morrison Pty Ltd
    Mentone, VIC, Australia
    ------------------------------



  • 5.  RE: How do you connect SSA to T1 or another database server?

    Posted 10-27-2021 20:24
    Thank you much James.
    I'll study it.
    Cheers.

    ------------------------------
    Ayman Hamzeh
    Spatial Analyst
    Sydney Spatial Services
    Sydney NSW
    ------------------------------