I tried to google this but I failed.
Is there a way (I know it is, found this link but with insufficient details) to connect to crystal server's database?
We are runnig many reports daily which sometimes fail, sometimes don't run at all, we accept this as a part of server imperfection. The issue is, that checking each reports instance through CMC is very inconvenient and time consuming. If I could check it directly in some other way it would be much easier to manage.
The server version is 12.0
connecting to crystal server database
1.2k Views Asked by avb At
1
There are 1 best solutions below
Related Questions in CRYSTAL-REPORTS
- Crystal Reports and Null fields
- Crystal Reports extracting text within delimiters
- "Blank" pages in crystal reports with groups
- How to sum filed based on day type in crystal report
- Crystal Report Pie Chart Formula Labels
- how to pass value to crystal report parameter filed from the code
- C#&Crystal Reports, Failed to Load database error
- Crystal Reports - How to include more than one data value in my report
- Crystal report to rounding
- crystal reports fill with lines
- Year and month in a crystal report
- published reports don't work - Database logon failed Error
- Crystal Report not display in Crystal report viewer
- Crystal Report page split up and encrypting the generated document in C#
- Dynamic sort group in crystal reports
Related Questions in BUSINESS-OBJECTS
- Using fields from different universes in Business objects
- An internal error occurred while calling 'saveDocumentToCorporateMDP' API. (Error: ERR_WIS_30270)
- How to schedule BO report to refresh using historical dates?
- How does SAP BusinessObjects make calls to a Hana Database?
- What are the similarities and differences between SAP BusinessObjects and XS Engine?
- How to refresh business view in Crystal Reports?
- Business Objects - Summarising Data in a Separate Report
- How to sort prompt values in a Webi report?
- Why does sorting not happen to the reports when the reports in development is migrated to stage?
- Dependent filters in Webi report
- Define number format in Webi Report 4.1
- Character to number conversion
- OLE DB Provider CLSID not specified or erroneous
- Creating Time Dimension in BusinessObjects
- Derived Table(View) is required
Related Questions in CRYSTAL-REPORTS-SERVER
- How to sum filed based on day type in crystal report
- Scheduled Recurring Crystal Reports have status "Pending" No matter what
- Crystal Reports Server 2011 character set compatibility
- How to export report files from Crystal Enterprise 10 server?
- Crystal report PDF font issue for japanese characters using Java
- Whenever I drag the Crystal Report Viewer to show the form it goes down without showing from view
- How to Print specific row in each page Crystal Report
- Getting file path from Business Objects Enterprise programmatically
- Can't find database in Crystal Report in Visual Studio 2010
- Crystal Reports cannot find file
- Crystal report errors on server
- printing multiple crystal reports in client side with just a click, which are formed in server side
- connecting to crystal server database
- Barcode not working on Crystal Server 2011
- SQL Reporting Services 2008 compared Crystal Reports?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
While the CMS repository is a plain database, querying it directly (using SQL) is discouraged, unsupported and generally a bad idea.
If you want to query the repository, you have several other options:
Use the built-in Query Builder web application (a web application called
AdminTools, normally deployed on your application server). This offers a SQL-like interface for querying the repository, though a lot of SQL features are not available (e.g. table joins). Official documentation is also generally lacking for Query Builder, but if you're interested, there's a very good guide available here.Use the Java or .NET SDK to query the repository. SDK documentation is available on SAP SCN. This is the most powerful option, but also requires you to do everything yourself. And it will take some time to become familiar with all the different classes and how they relate to the BI Platform.
Use a 3rd-party tool. Different solutions exist, with different feature sets, although it seems that most stopped working when BI4 came out, and the ones that exist usually require a server component as well.
Additional information:
You could also more-or-less automate the querying of the repository (although it's very basic) by following the instructions outlined in this blog post.