Highlighted
Established Member..
Established Member..
719 views

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

0 Likes
1 Reply
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

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

Micro Focus Software Support

The views expressed in my contributions are my own and do not necessarily reflect the views and strategy of Micro Focus.

If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
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.