Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

I have two data adapters (SQL Server) configured, both conne...


Tim Easley

Recommended Posts

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

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

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...