Neek

Hi I am Getting an error while connecting to oracle database throught BDC Application Definition File .

error : "Business data Catalog is configure improperly"

On investigating the error in logs i found that Connection string used by .net Connection manger throws an error that "Connection string is not proper"

It has Initial Catalog as invalid entry.

Application definition XML used is below:

< xml version="1.0" encoding="utf-8" standalone="yes" >
- <LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsiTongue TiedchemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="1.0.0.2" Name="EmpInfo" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
- <Properties>
<Property Name="WildcardCharacter" Type="System.String">%</Property>
</Properties>
- <LobSystemInstances>
- <LobSystemInstance Name="EmployeeInfoInstance">
- <Properties>
<Property Name="DatabaseAccessProvider" Type="System.String">Oracle</Property>
<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
<Property Name="RdbConnection Data Source" Type="System.String">10.84.21.14</Property>
<Property Name="RdbConnection User ID" Type="System.String">LN_CIF</Property>
<Property Name="RdbConnection Password" Type="System.String">LN_CIF_01</Property>
<Property Name="RdbConnection Initial Catalog" Type="System.String">CIFDW</Property>
<Property Name="RdbConnection Unicode" Type="System.String">True</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String" />
</Properties>
</LobSystemInstance>
</LobSystemInstances>
- <Entities>
- <Entity EstimatedInstanceCount="0" Name="HR.Employee1">
- <Properties>
<Property Name="Title" Type="System.String">View Profile</Property>
</Properties>
- <Identifiers>
<Identifier TypeName="System.Decimal" Name="Employee_ID" />
</Identifiers>
- <Methods>
- <Method Name="GetHR.Employee1">
- <Properties>
<Property Name="RdbCommandText" Type="System.String">Select Employee_ID,Name,Title,Manager_Id,Hire_Date from CIFDW.my_bdc_test Where (Employee_ID > =:GeneratedMinEmployeeID) and (Employee_ID < = :GeneratedMaxEmployeeID)</Property>
<Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
</Properties>
- <FilterDescriptors>
<FilterDescriptor Type="Comparison" Name="Employee_ID" />
</FilterDescriptors>
- <Parameters>
- <Parameter Direction="In" Name=":GeneratedMinEmployeeID">
- <TypeDescriptor TypeName="System.Decimal" IdentifierName="Employee_ID" AssociatedFilter="Employee_ID" Name="GeneratedMinEmployeeID">
- <DefaultValues>
<DefaultValue MethodInstanceName="HR.EmployeeFinder" Type="System.Decimal">0</DefaultValue>
<DefaultValue MethodInstanceName="HR.EmployeeSpecificFinder" Type="System.Decimal">0</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
- <Parameter Direction="In" Name=":GeneratedMaxEmployeeID">
- <TypeDescriptor TypeName="System.Decimal" IdentifierName="Employee_ID" AssociatedFilter="Employee_ID" Name="GeneratedMaxEmployeeID">
- <DefaultValues>
<DefaultValue MethodInstanceName="HR.EmployeeFinder" Type="System.Decimal">999999</DefaultValue>
<DefaultValue MethodInstanceName="HR.EmployeeSpecificFinder" Type="System.Decimal">999999</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
- <Parameter Direction="Return" Name="HR.Employee">
- <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="HR.EmployeeDataReader">
- <TypeDescriptors>
- <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="HR.EmployeeDataRecord">
- <TypeDescriptors>
<TypeDescriptor TypeName="System.Decimal" IdentifierName="Employee_ID" Name="Employee_ID" />
<TypeDescriptor TypeName="System.String" Name="Name" />
<TypeDescriptor TypeName="System.String" Name="Title" />
<TypeDescriptor TypeName="System.Decimal" Name="Manager_Id" />
<TypeDescriptor TypeName="System.DateTime" Name="Hire_Date" />
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
- <MethodInstances>
<MethodInstance Type="Finder" ReturnParameterName="HR.Employee" Name="HR.EmployeeFinder" />
<MethodInstance Type="SpecificFinder" ReturnParameterName="HR.Employee" Name="HR.EmployeeSpecificFinder" />
</MethodInstances>
</Method>
- <Method Name="HREmployeeIDEnumerator">
<!--
 Method for enabling business data search. The method 
     returns a list of IDs. Business Data Catalog will use the 
     SpecificFinder method on each of these IDs when indexing 
     the prodocuts.
-->
- <Properties>
<Property Name="RdbCommandText" Type="System.String">SELECT Employee_ID FROM CIFDW.my_bdc_test WHERE Employee_ID > 123 AND Employee_ID < 125</Property>
<Property Name="RdbCommandType" Type="System.String">Text</Property>
</Properties>
- <Parameters>
- <Parameter Name="Employee_IDs" Direction="Return">
- <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="HR.EmployeeIdsDataReader">
- <TypeDescriptors>
- <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="HR.EmployeeIdDataRecord">
- <TypeDescriptors>
- <TypeDescriptor TypeName="System.Int32" IdentifierName="Employee_ID" Name="Employee_ID">
- <LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">ID</LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
- <MethodInstances>
<MethodInstance Name="HREmployeeIDEnumeratorInstance" Type="IdEnumerator" ReturnParameterName="Employee_IDs" />
</MethodInstances>
</Method>
</Methods>
<!--
			<Actions>
				<Action Position="1" IsOpenedInNewWindow="false" Url="http://mossint:20000/ssp/admin/Content/HumanResources.Employee1.aspx EmployeeID={0}" ImageUrl="/_layouts/1033/images/viewprof.gif" Name="View Profile">
					<ActionParameters>
						<ActionParameter Index="0" Name="EmployeeID" />
					</ActionParameters>
				</Action>
				<Action Position="1" IsOpenedInNewWindow="true" Url="http://www.google.com/search q={0}" ImageUrl="" Name="Search on Google">
					<ActionParameters>
						<ActionParameter Index="0" Name="Title" />
					</ActionParameters>
				</Action>
			</Actions>
-->
</Entity>
</Entities>
</LobSystem>
can some one please Help me out
//Thanx in advance
// neek



Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

Frank Chiang

I have seen another example that specify a 'data source name' - which is what you specify in ODBC connection; and there is no need for 'Initial Catalog' as it is specified in 'Data Source Name'





Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

Nick Swan

Oracle doesn't seem to have the concept of databases, just a server that has tables, and then user accounts that have permissions to access the tables. This should work for you though...

<LobSystemInstances>
<LobSystemInstance Name="OracleInstance">
<Properties>
<Property Name="DatabaseAccessProvider" Type="System.String">Oracle</Property>
<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
<Property Name="RdbConnection Data Source" Type="System.String">localhost</Property>
<Property Name="RdbConnection Pooling" Type="System.String">false</Property>
<Property Name="RdbConnection User Id" Type="System.String">HR</Property>
<Property Name="RdbConnection Password" Type="System.String">******</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String" />
<Property Name="WildcardCharacter" Type="System.String">%</Property>
</Properties>
</LobSystemInstance>
</LobSystemInstances>

BDC Meta Man will have oracle support soon!

HTH

Nick






Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

Neek

Thanx Nick ,

Got busy with some work so replying late will try out and let you know .But there also seems to be an issue with Driver

version of oracle adapters i am investigating that ...will soon Blog if not able to overcome it...






Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

Neek

Hi Nick ,

I did test it and it is working.

i also tried usign single sign On and

was able to do with help of that also.

Thanx Again

//neek






Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

Kish_MOSS

Any body can help me to connect oracle with windows authentication.

<LobSystemInstance Name="OracleEIns">

<Properties>

<Property Name="DatabaseAccessProvider" Type="System.String">Oracle</Property>

<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>

<Property Name="RdbConnection Data Source" Type="System.String">server</Property>

<Property Name="RdbConnection Pooling" Type="System.String">false</Property>

<Property Name="RdbConnection Integrated Security" Type="System.String" />

</Properties>

</LobSystemInstance>

what wrong here

-Kish





Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

Neek

Kish ,

is ur data base server and share point server on the same box if not then

u can try with single sign on instead of Pass through.If u are not able configure single sign On then let know i will send u a detailed doc. how to configure and make it work.

//Neek






Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

ActionManAce

can u send me ur SSO doc



Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

er.ashish

Can you please send me SSO doc that you have Also I am facing some other issues while trying to make BDC editor work with Oracle ADF. I would appreciate if you can send me any sample file that you have which does wildcard search on non primary key field.

Thanks,

Ashish






Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

neethi

Hi,

I need to fetch oracle data in to a sharepoint site.

If you have an oracle application definition file sample then do shre it with me.

Regards,

Neethi






Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

Neek

Please send me ur mail IDs i will do that....also send me a Oracle database schema so that i can develop and give u an ADF explaning every thing.






Re: SharePoint - Business Data Catalog BDC + Oracle + MOSS 2007 + Application definition File

NaveenPN

Me also want to fetch oracle data in to a sharepoint site.I want to get the data available in an oracle view in my sharepoint site .

The oracle database and sharepoint sites are in two diffrent servers .

Do i require any oracle client installation on my sharepoint server to acess the oracle database and I tried creating an application definition file similer to one explained in the previous posts but it was giving me some errors .

If you have an oracle application definition file sample then plz share it with me.

my mail id is :naveenpn13@gmail.com