Microsoft OLAP Integration With ODI?
Aug 22, 2012Do we have KM available in ODI 11g for integration with Microsoft OLAP?
View 1 Replies
ADVERTISEMENT
Extract Data For Express 6 OLAP?
Sep 8, 2007Is there a way where i can extract the data from Oracle Express 6 (OLAP data) into an excel or any other format, so that the same can be loaded onto a MS Sql or a normal Oracle database.
View 1 Replies View RelatedServer Administration :: OLAP Installation On 10g
Apr 9, 2012I am using the oracle version 10.2.0.1. on windows XP platform.I need to install OLAP.
View 5 Replies View RelatedUpgrade :: Oracle OLAP API Invalid At 11.2.0.3
Sep 14, 2012I upgraded a database on Win64 from 11.2.0.1 to 11.2.0.3 Patch 10.
The 'Pre-Upgrade Information Tool' said 'Oracle OLAP API [upgrade] INVALID' bevore the upgrade. The upgrade procedure didn't then do the upgrade of OLAP. Now several objects of OLAPSYS and the object CTXSYS.DRIOPT are invalid and can not be validated by compilation. What should i do now?
SQL & PL/SQL :: Bug In Timestamp Data Type In Oracle DML / OLAP Or User Error
Mar 20, 2012I'm trying to deduct x hours from a timestamp value. Everything works fine if x yields a result that is on the same day as the value I'm deducting it from. However, if it yields the day before then it gives the wrong answer using DML (although in SQL it works fine). Let me explain with an example:
Let's say current_timestamp is 20-MAR-12 09.40.00.000000 +00:00
If I deduct 8 hours from this I get the correct answer: 20-mar-12 01:40:00 (syntax: show current_timestamp-8/24)
If however, I deduct 10 hours from it (which takes it to the day before) I get garbage: 20-mar-12 00:20:00 (syntax: show current_timestamp-10/24). It should say: 19-mar-12 23:40:00
In SQL I get the correct result every time. So, my question is, is this a bug or intended behaviour? If the latter then what is it doing and how can I get it to give the answer I'm looking for?
What I'm trying to do is convert a timestamp from one timezone to another using DML. The NEW_TIME function will only give me what I want if I know whether the "to" timezone is currently in daylight saving or not. eg. Must I use CST or CDT?
The full syntax I'm using to try and achieve my aim is below.
show to_char( to_date( '2012-03-19--15-37-23' 'YYYY-MM-DD--HH24-MI-SS' )-(convert( extchars( tz_offset( 'AMERICA/CHICAGO' ) 3, 1 ) int )/24) 'YYYY-MM-DD--HH24-MI-SS' )
where 2012-03-19--15-37-23 is a user-supplied argument.
Active Directory Integration With EBS
Jun 3, 2013I have task to integrate AD users with oracle ebs r12 . Is there any mechanism to do it directly without OID between oracle ebs and Active directory during login to ebs or i have to install OID to finish that task .
View 1 Replies View RelatedApplication Express :: Integration With R12?
Aug 20, 2012I have been trying to follow the paper
[URL]
by Rod West. I am having problems getting the .jsp to compile
Here is my previous thread --> [URL]
Here is my current compilation issue. I am trying to use the .jsp code contained in the document FIGURE 9.
bash-3.00$ /u00/oracle/mont/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/ojspCompile.pl compile -s 'LaunchApex.jsp' retry
logfile set: /u00/oracle/mont/inst/apps/MONT_ofpt03/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling delta)
using 10i internal ojsp ver: 10
synchronizing dependency file:
loading deplist...8096
enumerating jsps...8096
[code].....
Windows :: System Integration CONSULTANT?
Jul 27, 2011I need information to recommend something to the Client:Existing Application Environment is:
OS: Windows XP Server as well as Client
Database: Oracle 9i Server on XP
Oracle Client : Oracle 9i
They want to move to Windows 7 in ClientWhat all they need to upgrade if required...?Does Oracle 9i Client can be installed on windows 7 clientDoes Oracle 10g Client is required in the above mentioned case.
Application Express :: Ext JS Desktop Integration
Sep 18, 2012It's possible to use Ext JS Desktop in apex . I put it in simple application ... what's the next step ?
[URL]..........
user:maie
password:123
TimesTen In-Memory :: Integration With Radware
May 2, 2013As per my understanding , Timesten or IMDB Cache can be connected through DSN by any external client. Want to know whether Radware can be integrated with Timesten or IMDB Cache.
View 1 Replies View RelatedNetworking And Gateways :: Mysql Oracle Integration
Sep 25, 2013I need to created DB link between oracle (10g on linux) and mysql 5.0 to configure a job to fetch data after every hour. I need solution that does not involve:
ODBC Connection
Oracle GateWay
Golden Gate
Application Express :: Integration With Google Map Visualization
Nov 1, 2013Is there a way I can integrate my customer base (over 100k with address information) to a Google map. High level, I want my user to enter an address and on google map it should show me markers for existing customers closer to that address.
View 3 Replies View RelatedForms :: Frm-41211 Integration Error / SSL Failure Running Another Product
Jan 20, 2010I have just migrated my database from oracle7 to Oracle9i. My application is still on forms 4.5 and reports 2.5.
i am having a problem after the migration. I am able to run my forms, but i cannot run my reports from my form (button). i am having the error : "frm-41211 integration error: SSL failure running another product". I want to mention that i am able to run the report from the report builder.
Forms :: FRM-41211 / Integration Error / SSL Failure Running Another Product
Feb 5, 2013I have a form with a button for "Print Report " when I click button following error occurred :
FRM-41211 :integration error : SSL failure running another product
SQL & PL/SQL :: Microsoft ODBC For Oracle And Autocommit
Feb 10, 2011I am using an Microsoft Access application which accessing an Oracle Database with ODBC.
each time i change data in the ACCESS forms, the change is committed in the database. I would like to know how to set the AUTOCOMMIT off.
Forms :: Microsoft TreeView Control 6.0
Mar 13, 2009I'd like to implement a treeview control with checkboxes in every node using Microsoft TreeView Control 6.0 in Forms 6i. I already did the following steps:
1. Download and register OCX (regsvr32 C:windowssystem32comctl32.ocx)
2. Draw OCX control on form.
3. Right click on OCX control and Insert Object "Microsoft TreeView Control 6.0"
4. Import OLE Library Interfaces "MSComctlLib.TreeCtrl.2"
5. Set Data Block Single Record to YES
6. Set OLE Class of Listview control to "MSComctlLib.TreeCtrl.2"
7. Rename treeview control to "ACX_TREE" and Data Block to "BLK_CONTROLS"
Now I need to populate the treeview adding code to the "WHEN_NEW_FORM_INSTANCE" Trigger, but I don't see how. how to do this and/or a place where I can find a working example?
Forms :: Integration Error - SSL Failure Running Another Product With HP Deskjet D2680?
Sep 14, 2011"Integration error: SSL failure running another product" with HP Deskjet D2680.We are using 10gR2, Forms6i, and Report6i. The server is Windows 2003 Server, and the OS of the printer is XPIn one of our module, upon calling one report we always encounter Integration error: SSL failure running another product. Sometimes when we do not encounter it, the spooling takes too much time and it takes 6minutes just to print the first page of the report, succeeding pages takes 2-3minutes in interval.
At first we thought that the memory of the PC is the problem, but we tried to connect it to a 2gig RAM Win7 laptop, another laptop with 1gig RAM XP, and a 1g RAM Desktop. We tested 5 computers but the same problem occurs.
The problem is not encountered after we tried other HP Printer(HP 3940, 6988, & D4360). I just want to know the problem with the HP Deskjet D2680.
Windows :: Data From Oracle To Microsoft Word
Jun 30, 2011I need to create a doc file using Microsoft Word where I can get data from an Oracle DB.
I search on MS Word, for something like ODBC (like in Excel and Access) but in vain.
I need to do this so I can format the data on the doc file in any way I want. Not like in Oracle Reports, where formatting is a little bit restrictive.
Windows :: Oracle Versus Microsoft OLEDB
Sep 2, 2011we are running a front end application on classic asp and we are using microsoft ole db version to connect to oracle 9i database.Now as the users are increasing daily, the application performance is degrading day by day.
my question is will oracle ole db increase the performance of my front end application. and is it possible for me to migrate from microsoft oledb to oracle oledb without much changes in the application.
Oracle 11.2.0.2.0 Running On Microsoft 2008 Cluster
Apr 8, 2013Is Oracle certified Oracle 11.2.0.2.0 to run under a Microsoft 2008 Cluster ?
View 6 Replies View RelatedForms :: Microsoft Product And Oracle Application Are In One Server?
Jun 19, 2012Bulk of Microsoft Application is running on windows server 2003 (OS) , is it possible to run parallel an oracle application on the same server .
View 4 Replies View RelatedWindows / .NET :: Microsoft Access Attachment Field And Oracle
Oct 1, 2012I'm using Microsoft Access 2007 as a front end to Oracle 10g tables using an ODBC Connection. I need to be able to add attachments to the records in one of my linked tables to hold emails, screen shots, log entries etc.
Access 2007 handles this capability with a field format called Attachment. I don't want to store the attachments locally but want them to be stored in Oracle, but I'm not sure what format the field in Oracle needs to be so that it will come across in Access as an Attachment field.
Installation :: Netca - Connect To Microsoft Active Directory
Jun 13, 2013Oracle Database 11.2.0.3.0 64bitI have followed most steps of this link and I came to a stop at the point where I use the Network Configuration Assistant.I have selected the following
1) Directory Usage Configuration>
2) Microsoft Active Directory>
3) Operation (2nd): Select the directory server you want to use, and configure the directory server for Oracle usage.>
4) Input my AD hostname>
5) Then it displays a message that "The directory contains an older version of the required Oracle Schema. Directory usage configuration cannot continue without the correct Oracle Schema. If you have authorization to create the directory schema then you can upgrade the Oracle Schema now. Would you like to upgrade the Oracle Schema? I have selected: Yes, I want to upgrade... and thereafter I get the errors:
The Assistant is unable to create or upgrade the Oracle Schema for the following reason:
ConfigException: Could not upgrade the Oracle Schema: oracle.net.config.ConfigException: TNS-004409 Directory Service Errorcaused by: oracle.net.config.DirectoryServiceException: TNS - 04431: DirectoryService: no entries foundcaused by: oracle.net.ldap.NNFLException.You may need to upgrade the directory schema from a specific computer which directly supports your directory type.
Command Line Error Response
ConfigException: Could not check for the Oracle Schema: oracle.net.config.Config
Exception: TNS-04409: Directory service error caused by: oracle.net.config.DirectoryServiceException: TNS-04431: DirectorySe
rvice: no entries found caused by: oracle.net.ldap.NNFLException
Windows / .NET :: Microsoft Exchange To Retrieve Data From Oracle DB
Aug 8, 2012My company already work with Oracle 10g, I developed an application using this database and asp.NET. It allows the management of BD and exploitation of these data by clients via ASP pages.
Now I must use Microsoft Exchange (especially the calendar) to retrieve data from the Oracle database and embed links to setup my ASP pages to the calendar.
Being new to Exchange, my questions are:
- It can be done?
- Should I use a particular driver?
- Some idea ?
Client Tools :: Oracle Services For Microsoft Transaction Server?
Apr 2, 2012I want to use SSIS,when i use oracle 10g as a data source to SQL Server 2008 as Destination, it gives error ora-01017 invalid username/password logon denied, i did normal oracle installation and give full privileges(sysdba or sysoper) to the user(sys,system...),when i check connection it shows test connection succeeded but when click on next it gives above error.
View 3 Replies View RelatedRAC/ASM Clusterware Installation :: Microsoft Cluster Service And ApEX - Compatible?
Jul 25, 2012I have been asked to look at making an existing Oracle server resilant. The technology I need to use are:
- Windows 2008 R2 Enterprise SP2
- Microsoft Cluster Services
- Oracle Enterprise 11g release 2
- Oracle Fail-Safe (latest version available)
Unfortunately ApEX 4.1 and Mod_plsql are install on the existing stand-alone server. I'm afraid i know very little about Oracle and ApEX but i need to make a design decision and check fiesablilty.
I believe the HTTP service and Mod_plsql can be moved to a independant server which should work but ApEX itself must remian on the database server (i'm told).Will ApEX work in a MSCS setup? I can only find references to RAC support, RAC is out of scope.
Run A New Database In Microsoft Access To Import Tables Through ODBC - Get Error?
Mar 5, 2013We are test Uniform ODBC drivers. When we run a new Database in Microsoft Access to import tables through the ODBC we get this error
Internal Error – unable to initialise NLS during driver load.
Forms :: Open Document Present In Shared Drive In Microsoft Word?
Feb 23, 2011I want to open a word document which is present in a shared drive in Microsoft word from my oracle 10g form.
View 2 Replies View RelatedReports & Discoverer :: Unable To Open Report In Microsoft Office Excel Format
Jul 6, 2010I m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
Server Utilities :: How To Load Data In Oracle From Microsoft Access Database (MDB) File
Aug 24, 2012I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.
View 6 Replies View Related