Connecting with Microsoft Access .mdb Databse

CloverDX Platform
1

Hallo,

I am having problems connecting to an local .mdb file.
I have seen the following topics, but these didnt solve my problem.
- http://forum.cloveretl.com/viewtopic.php?f=4&t=5093
- viewtopic.php?f=4&t=167

My problem is with making the Database connection.
It doesn’t validate the connection and the following error

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The url ill input is

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=G:\Database.mdb

.

I have also included the database file.

2

Have you seen this post: Consuming an Access Database ?

Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.

3

Have you seen this post: Consuming an Access Database ?

Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.

“dpavlis”

Yea i have already noticed that. In the 64 bit ofbc there isnt an access driver installed. I made a work around for it for so long. Made a xml file but now it seems not getting true, caused by metadata

4

The XML file looks like this

<Geheugenpoli1><Line><Naam>Client 176</Naam><PatientNr>2010176</PatientNr></Line><Line><Naam>Client 93</Naam><PatientNr>2010093</PatientNr></Line>

The XML Map looks like this

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="Geheugenpoli1" type="Geheugenpoli1Type"/>
  <xs:complexType name="LineType">
    <xs:sequence>
      <xs:element type="xs:string" name="naam"/>
      <xs:element type="xs:int" name="PatientNr"/>
    </xs:sequence>
  </xs:complexType>
  <xs:complexType name="Geheugenpoli1Type">
    <xs:sequence>
      <xs:element type="LineType" name="Line" maxOccurs="unbounded" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:schema>

So what kind of meta do i need to make?

I created the following

Line
- String naam
- String PatientNr

5

Hmm, what does this have to do with MS Access ? It looks like you want to parse some XML data.
For this, use XMLExtract component (the fact that you have XML schema for your data will help) - see XMLExtract reference in Clover doc.

There is also a section (video) about XML processing in Clover Quick Start Guide.

In any case, you will have to create metadata carrying fields which you will be filling from the XML data - so your guess is correct. The video listed above shows all this.

6

Hmm, what does this have to do with MS Access ? It looks like you want to parse some XML data.
For this, use XMLExtract component (the fact that you have XML schema for your data will help) - see XMLExtract reference in Clover doc.

There is also a section (video) about XML processing in Clover Quick Start Guide.

In any case, you will have to create metadata carrying fields which you will be filling from the XML data - so your guess is correct. The video listed above shows all this.

“dpavlis”

This is a workaround for now

7

Have you seen this post: Consuming an Access Database ?

Your error is sometimes caused by 32/64bit ODBC Driver & JVM (32/64bit) mismatch.

“dpavlis”

Thanks for sharing