Skip to main content
Question

How can I see database info behind ODBC connection?

  • November 6, 2019
  • 1 reply
  • 42 views
agelfert
Contributor
Forum|alt.badge.img+8

Hate to be vague with my question. It's quite possible the solution lies outside of FME, too.

I have inherited a large workspace with multiple SQL Creators that use ODBC connections. There is a database name listed, and under 'Parameters' there are credentials. There is a SQL statement. Neither tables nor dataset sound familiar.

So I have no idea what this actually connects to. There is no way for me to find that through FME, is there? I'm thinking this was either setup through DSN but I haven't located a file, or another way. Any insights would be helpful.

1 reply

nic_ran
Contributor
Forum|alt.badge.img+16
  • nic_ranContributor
  • Contributor
  • November 7, 2019

FME does not store any more information for embedded connections other than what you'll be seeing in the SQLCreator's, so I'm afraid that FME won't be able to help you much.

One potential idea is to create a copy of one of the existing SQLCreators, complete with embedded credentials (I think this should retain the existing password), and use that to issue some DDL commands to get info from the DB. Obviously, the commands you need to issue would be dependent on the type of DB you're connecting to (SQL Server, Oracle, etc.)

Of course, moving forward, you should be using DB connections in FME, rather than embedded connections, but that's another matter entirely and still wouldn't really help you in this case.

Reply


Helpful Members This Week

Community Stats

30,996
Posts
117,482
Replies
38,778
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.