Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Report Caster using Direct SQL by the use of a synonym
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]Report Caster using Direct SQL by the use of a synonym
 Login/Join
 
Member
posted
I have been working with WF for about 8 months and now I have been asked to create a Report Caster that uses Direct SQL by the use of a Synonym to enhance our performance time. However, I have never created a Synonym before and was looking for some help.

I've done some research about SQL Passthrus and Direct SQL on the forums. The company I work for has done stored procedures by the use of Synonyms. Is there any technical tools that I can find to help with this development or can anyone explain to me what I need to do?

Thanks ahead of time,
Nick

This message has been edited. Last edited by: <Emily McAllister>,
 
Posts: 5 | Registered: September 03, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
Hi NickSmith

A good starting point is to review the IBI documentation.

Technical Content Library

Please update your profile to let us know what version of WebFOCUS you are using.

Assuming WebFOCUS 8105 ( you can find similar documentation for your version in the same location - click on your version )

You will find the list of documents on the left, click on the "+" to expand the list. Each have a PDF at the end of the list.

At the top you can perform a search for topics - enter SQL synonym - several related topics will appear.

Other topics to search for:

Creating Synonyms
Managing Microsoft SQL Server Metadata

Hope this helps you out.

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.
* Summit 2016 – June 13-17 in Reno, Nevada  - http://www.informationbuilders.com/events/summit


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Report Caster using Direct SQL by the use of a synonym

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.