UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

DB Import / Export with Sybase SQL Anywhere

Occasional Contributor

DB Import / Export with Sybase SQL Anywhere

Hi all,

We have to export data from UCMDB 10 to a DB table and to import data from a DB table to UCMDB. We already did it with Oracle database, using Generic DB Adapter for import and Generic Push Adapter for export, but we have to do it just now with a Sybase SQL Anywhere Database.

Any experience with this database or with another “rare” one?

As far as I read, I assume that it’s possible:

For Generic DB Adapter, I found “The Persistence.xml File is used to override the default Hibernate settings and to add support for database types that are not out of the box (OOB database types are Oracle Server, Microsoft SQL Server, and MySQL). If you need to support a new database type, make sure that you supply a connection pool provider (the default is c3p0) and a JDBC driver for your database (put the *.jar files in the adapter folder). To see all available Hibernate values that can be changed, check the org.hibernate.cfg.Environment class (for details, refer to http://www.hibernate.org.)”

For Generic Push Adapter, I’m afraid I should create a new Pyhton script and import drivers.

Any example, quick-steps or experience is welcomed.

Thanks a lot!

 

Borja

1 REPLY
Neighborhood Admin

Re: DB Import / Export with Sybase SQL Anywhere

Hi,

 

We have an expert day going on today in our entitled forum which is only accessible and viewable for customers with a valid SAID (Support Agreement ID) in your profile. I see that you have access. so if you want you can submit your question to this forum:

UCMDB and UD Support Customer Forum 

You need to be logged in to see and access this forum. Also outside of the expert day we always have support engineers in this forum that can address your questions.

Greetings,

 

Bill

//Add this to "OnDomLoad" event