Tim Easley Posted December 29, 2021 Share Posted December 29, 2021 I have two data adapters (SQL Server) configured, both connect to the same database but they use different credentials. If I create metadata using one of the adapters, I assumed I would see something in the .acx file that points to the adapter used to create it but I do not. I searched the Describing Data with TIBCO WebFOCUS Language and get 16 hits for the word adapter but none of them describe a .acx file setting. Thanks! Link to comment Share on other sites More sharing options...
David Briars Posted December 29, 2021 Share Posted December 29, 2021 In the .acx do you see a CONNECTION attribute SEGNAME=ABC, TABLENAME=XX.YYY, CONNECTION=MYCONNECTION, $ Link to comment Share on other sites More sharing options...
Tim Easley Posted December 29, 2021 Author Share Posted December 29, 2021 No I dont (example below), but thanks for providing the keyword. Now Im wondering why (or why not) this setting would be included (or not included) in the .acx. Thanks for your reply, I will do some searching to see if I get CONNECTION always added to the .acx. But knowing this I can add manually where necessary. Example: SEGNAME=BI_DM_DETAIL, TABLENAME=dbo.BI_DM_DETAIL, KEYS=0, $ Link to comment Share on other sites More sharing options...
Tim Easley Posted December 29, 2021 Author Share Posted December 29, 2021 Ok I found that this is an OPTIONAL setting in the adapter. If you choose the Advanced Parameters in the adapter setting you can add a connection description. Then, when creating metadata the CONNECTION setting is added to the .acx. Thanks for your help! Link to comment Share on other sites More sharing options...
Martin Yergeau Posted December 29, 2021 Share Posted December 29, 2021 tim.easley: you can add a connection description This is not what David was talking about. The line : CONNECTION=MYCONNECTION, $ mentioned by David should be part of the .acx to defined the where the master file must read from. What you find is a comment added to the connection definition not at the .acx file But if what you have found makes you happy, its all good. but if that makes you happy Link to comment Share on other sites More sharing options...
David Hall 5 Posted December 29, 2021 Share Posted December 29, 2021 IF you have an adapter on the WFRS, the easiest way to pull up the adapter you have. Hit test to make sure it works. Then make a duplicate of it and give it a new connector name. We do this for the WF Repository where we have a 2nd one with the letters RO added for read only. We then change the credentials and verify it works. If you want to look at the Access file, select the master from the application folder and right click, You should see a menu like the following: Select Metadata Management and you can then edit the Access file and see the contents Here you can change which connector you plan on using Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now