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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Oct 19.

PostgreSQL and DS


 
Search this topic... | Search DI: Installation, Administration, and Connectivities... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Author Message
simbo
Forum Member
Forum Member



Joined: 02 Feb 2018

Posts: 1



PostPosted: Fri Feb 02, 2018 10:15 am 
Post subject: PostgreSQL and DS

Hi all,

This is quite generic request. We are about to embark on a development project and are planning on using Data services 4.2 SP 10. The project will use PostgreSQL databases (primarily version 9.6 but other versions exist in the estate). PostgreSQL dbs are both source and target databases in this project. We are currently planning on using the Data Direct 7.1 drivers that Data services comes bundled with.

Has anyone any experience of using Data Services with PostgreSQL and are there any issues?

In my searches I've come across some issues with JSON data types that can be resolved and some concerns but not much else raising any issues or positives.

It would be good to know of any issues that may arise in the environment but also information from anyone using the same environment successfully.

Many thanks
Back to top
brudosm
Forum Member
Forum Member



Joined: 12 Dec 2014
ASUG Icon
Posts: 10
Location: USA



PostPosted: Mon Feb 05, 2018 1:48 pm 
Post subject: Re: PostgreSQL and DS

Thanks for the info. I don't have any experience, but will also need to access Postgres in the near future, so I will be watching this thread.
Back to top
ErikR
Forum Enthusiast
Forum Enthusiast



Joined: 10 Jan 2007

Posts: 1108
Location: Wellington, NZ


flag
PostPosted: Sun Feb 11, 2018 8:26 pm 
Post subject: Re: PostgreSQL and DS

I haven't had any issues sourcing from or writing to PostgreSQL using Data Services 4.2 as long as you stick to the ANSI-92 SQL data types. Embedded JSON structures may be an issue though?

Do note that PostgreSQL isn't supported for BODS repositories.

_________________
Erik Roelofs
Soltius NZ - SAP Gold Partner
"New Zealand's most trusted SAP provider"

SAP Certified Application Associate - Data Integration with SAP Data Services 4.x
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  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.0327 seconds using 17 queries. (SQL 0.0029 Parse 0.0009 Other 0.0289)
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