Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Let's Talk Data Quality Suite

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Let's Talk Data Quality Suite
 Login/Join
 
John_Edwards
Virtuoso
posted
Thought I'd open a discussion to people new to DQS. I've been through the course 980 materials and I'm working the tutorial in the DQS install right now.

I'm stumbling though, because I don't see an example of drawing data from a database. The demo material all works off of flat files. I see an example using the JDBC connection in the tutorial (and I understand the selection process once I have the database connection) but here's the thing -- I want to read data from SQL*Server, and my I-Way install have half a dozen connections the databases at my location.

How do I connect to an I-Way connection in DQS?

This message has been edited. Last edited by: <Kathryn Henning>,



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
CraigSanders
Member
posted Hide Post
John, you can't use an existing iSM connection in DQS or MDS. You will need a separate connection in DQS.

If you have specific questions about database connections in DQS/MDS please let me know.


sincerely,
Craig Sanders
Integrity Solutions Product Manager - DQS/MDS


all things iWay
 
Posts: 8 | Registered: August 13, 2014Report This Post
John_Edwards
Virtuoso
posted Hide Post
Lucius McInnis in the DC branch got me set up creating a connection to SQL*Server via JDBC. It looks like I just need to plan to make all connections via JDBC.

I followed his cheat sheet for it and made my connection just fine, even played with some data to make sure I had the whole thing working. But -- I exited DQS and returned to it, and my connection disappeared. The configuration did not get permanently saved in the environment.

That's the next task, which may be a permissions issue on Win2008.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
John_Edwards
Virtuoso
posted Hide Post
Update -- I redid the connection with Lucius in on a webex, did everything the exact same way and this time it saved. The mere presence of Lucius' voice in the room was sufficient to solve the problem.

Information Builders SEs have remarkable healing skills.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Let's Talk Data Quality Suite

Copyright © 1996-2020 Information Builders