Established Member..
Established Member..

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!



1 Reply
Micro Focus Expert
Micro Focus Expert

Re: DB Import / Export with Sybase SQL Anywhere

This type of question has been asked before and the only supported db types are the 3 you mentioned (not even PostgreSQL as of this writing).  You may submit an ER to have this documented, or request the DB type be added to the supported DBs list.



Hope this helps,
Keith Paschal
UCMDB Worldwide Support Lead
Micro Focus Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."

Click the KUDOS star on the left to say 'Thanks'
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.