Error With Informatica Server.6.0 And Client 9.01
WizardInformatica Cloud for Amazon AWSComplex Event ProcessingProactive Healthcare Decision ManagementProactive MonitoringReal-Time Alert ManagerRule PointData IntegrationB2B Data ExchangeB2B Data TransformationData Integration HubData ReplicationData ServicesData Validation OptionFast CloneInformatica PlatformMetadata ManagerPowerCenterPowerCenter ExpressPowerExchangePowerExchange AdaptersData QualityAddress DoctorAddress Doctor CloudData as a ServiceData ExplorerData QualityData Quality Services (Strike Iron)Data Security Group (Formerly ILM)Data ArchiveData Centric SecuritySecure@SourceSecure TestingMaster Data ManagementIdentity ResolutionMDM Big Data Relationship ManagementMDM Multidomain EditionMDM Registry EditionProcess AutomationActiveVOSCloud ExtendProduct Information ManagementInformatica ProcurementProduct Information ManagementUltra MessagingUltra Messaging OptionsUltra Messaging Persistence EditionUltra Messaging Queuing EditionUltra Messaging Streaming EditionVibe Data StreamDocumentationKnowledge BaseResourcesPAM (Product Availability Matrices)Support TVInformatica Expert AssistantVelocity (Best Practices)Mapping TemplatesDebugging ToolsUser Groupsglobal.search.communityLog inSign Up Informatica Network > Data Integration > PowerCenter > Discussions Please enter a title. You cannot post a blank message. Please enter your message and try again. 4 Replies Latest reply: Nov 6, 2014 3:18 AM by Pradeep Agrawal Datadirect odbc driver or other odbc driver? xm wang Dec 23, 2011 1:06 AM I have configured the Informatica server 9.0.1 on Linux successfully , and data migration of Aster2Aster, Aster and flat file is OK.But I met problem to migrate data between Aster and Sqlserver, which due to the SQL server ODBC connection failure in infa server.The Informatica installation includes DataDirect 6.0 ODBC drivers($INFA_HOME/ODBC6.0/lib),and we configured such variables:. INFA_HOME, LD_LIBRARY_PATH, ODBCHOME(=INFA_HOME/ODBC6.0), ODBCINI(=/root/.odbc.ini).We added new entry for the ODBC data source to connect Sql Server and Oracle with DataDirect 6.0 ODBC drivers(DWmsss24.so, DWora24.so) in odbc.ini. Notes the two drivers can be loaded successfully with "ddtestlib” tool
- Installation and Configuration (9.0.1 for OEL Linux 64Bit) PowerCenter - Installation and Configuration (9.0.1 for OEL Linux 64Bit) In Progress Table of Contents 1 - About 2 - Articles Related 3 - Prerequisites 3.1 - The platform 3.2 - Download the files 3.3 - Oracle Database 3.3.1 - parameter 3.3.2 - Repository Account 3.3.3 - Repository Tablespace 3.4 - Operating System 3.4.1 - Processor 3.4.2 - Temporary Disk Space Requirements 3.4.3 - User Account 3.4.4 - Port 3.4.5 - Environment Variables 3.4.6 - File Descriptor 3.4.7 - Installation directory and Permission 4 - Server 4.1 - Pre-Installation System Check 4.2 - Initial Server Software Installation 4.3 - Repository Configuration 5 - Client https://network.informatica.com/thread/38871 6 - Support 6.1 - The creation of the repository hangs 7 - Reference 1 - About This article talk about the installation of PowerCenter from Informatica on: Oracle Entreprise Linux 64 bit version 5 Update 5 Oracle Database 11gR2 I have made it in the context of an Oracle Business Intelligence Application version 7.9.6.3 installation then it's why the computer name is di-obia-01. After you complete the installation and configuration process, you http://gerardnico.com/wiki/powercenter/installation_901 have to log in to the Administrator tool to create and configure the following services: PowerCenter Repository Service PowerCenter Integration Service 2 - Articles Related PowerCenter - Installation 3 - Prerequisites 3.1 - The platform Linux: Linux - Installation The oracle database must be already installed: Oracle Database 11gR2 - Installation on Linux OEL 5 Update 5 (x86_64) 3.2 - Download the files The files for the software Informatica PowerCenter and PowerConnect Adapters 9.0.1 are available on Edelivery.com Choose: Oracle Business Intelligence on Linux x86_64 and click Go You must download this files: The file “Informatica PowerCenter and PowerConnect Adapters Client 9.0.1” contains: the Windows Client the documentation the license key The part 1 and 2 are multipart archive (.z01, .zip), you can use WinZip or Winrar to decompress it The file “Informatica PowerCenter and PowerConnect Adapters 9.0.1 for Linux x86 (64-bit)” contains: the server the patch The Oracle key (File2>Oracle_All_OS_Prod.key) is not valid for the installation of : PowerCenter - Data Analyzer and PowerCenter - Metadata Manager 3.3 - Oracle Database 3.3.1 - parameter Set the open_cursors parameter to 1000 SQL> SHOW parameter open_cursor; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors INTEGER 300 SQL> ALTER system SET open_cursors=1000; System altered. SQL> ALTER system SET open_cursors=1000 SCOPE=BOTH; System altered. SQL> SHOW parameter open_curso
database server, an Informatica PowerCenter server, and a Windows 2008 SP1 32 bit server with OBIEE Server & Admin Tool, DAC Server & Client, Informatica PowerCenter Client, and an Oracle Database https://docs.oracle.com/cd/E35225_01/doc.11/e29108/install.htm Client. All installation and configuration actions must be performed as an administrator or root user. This section describes the detailed Oracle Argus Analytics installation process. It also describes the pre and post Oracle Argus Analytics installation tasks that you must complete for different environments. This section includes the following topics: Preinstallation Configuration Running the Oracle Argus Analytics Installer Preparing the DAC Repository Configuring error with the OBIEE Repository and Webcatalog Configuring the OBIEE Help files Configuring SSO Using Oracle Access Manager Creating Users and Groups in Oracle Argus Analytics Configuring SSL for Oracle Argus Analytics in OBIEE OBIEE Default Application Roles Preinstallation Configuration Prior to running the Oracle Argus Analytics Installer, the following tasks must be completed: The TNS entries for both the Data Mart Schema and the Argus error with informatica Safety Database Schema should be present in the Informatica Server as well so that the ETLs can pick data from the Argus Safety Database and populate the same in the PVA Warehouse. The TNS entries for both the Data Mart Schema and the Argus Safety Database Schema should be present in the OBIEE 11g home in the path: