Skip to main content
Solved

Technology One Connector

  • May 7, 2024
  • 2 replies
  • 225 views

nbombardier
Contributor
Forum|alt.badge.img+1

Is anyone aware of a connector for FME that enables our GIS databases (Microsoft SQL) connect to a Techncology One Property & Rating database? 

Best answer by saraatsafe

Hi @nbombardier, there doesn’t seem to be a connector specifically for Technology One Property & Rating, but you should be able to create your own connector either using APIs or JDBC/ODBC. I’d suggest trying ODBC (documentation here) first since you’re working with SQL databases. I hope this helps!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

saraatsafe
Safer
Forum|alt.badge.img+11
  • Safer
  • Best Answer
  • May 8, 2024

Hi @nbombardier, there doesn’t seem to be a connector specifically for Technology One Property & Rating, but you should be able to create your own connector either using APIs or JDBC/ODBC. I’d suggest trying ODBC (documentation here) first since you’re working with SQL databases. I hope this helps!


nbombardier
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • May 13, 2024

@saraatsafe thanks,  our IT team is highly security conscious and isn't allowing sftp and I believe obdc connections off network. I'll investigate the API possibilities.