BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

JDBC Adapter Datastore, sql() error


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
jdow
Forum Member
Forum Member



Joined: 28 Mar 2013

Posts: 1



PostPosted: Wed May 17, 2017 2:59 pm 
Post subject: JDBC Adapter Datastore, sql() error

Hi All,

I'm working on an integration in Data Services 4.2.6 to read/load data in EDB via the jdbc adapter. I have the adapter instance configured and working. I've also created the corresponding datastore in Data Services. All of that appears to be working as expected. The challenge I'm running into is when attempting to use the sql() function with this jdbc adapter datastore. Data Services is throwing an error when I validate the job prior to execution:
Code:
[Script:Script_File_Chek_Transfer]
The script <Script_File_Chek_Transfer> contains an invalid expression. Additional information: <Adapter datastore <DS_JDBC_EDB> cannot be used in a sql() function because the adapter does not support this functionality.>. (BODI-1111242)


Has anyone experienced this issue while working with the jdbc adapter? Is there a solution that will enable us to use the sql() function with a jdbc adapter datastore?

Thanks, Jason
[/code]
Back to top
dopple
Principal Member
Principal Member



Joined: 19 Jun 2009

Posts: 197
Location: Edinburgh


flag
PostPosted: Wed Jun 12, 2019 6:10 am 
Post subject: Re: JDBC Adapter Datastore, sql() error

Has anyone else come across this? We're having the same issue. I can't see anything in the Adapters guide which suggests it shouldn't be supported. We're on 4.2 SP 11.
https://help.sap.com/doc/PRODUCTION/01f3c787a6e7499e86e25a556878cbef/4.2.8/en-US/ds_42_adapters_en.pdf
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0274 seconds using 18 queries. (SQL 0.0028 Parse 0.0008 Other 0.0237)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo