MS Access database connection in AEM

[admina26728807]

How to connect and access the ms access db (.mbd ) in aem can anybody help me in this how to proceed.

Thank in Advance

[MC_Stuff]

Hi Admina,

   Create datasource for your MDB. Then follow  https://docs.adobe.com/docs/en/aem/6-2/develop/platform/jdbc.html    Though document talkd about Microsoft SQL Server but approach works for mdb, excel etc....   Create system data source. then documentation of  JDBC Connection Pool Service ...

Thanks,

[kautuk_sahni · Accepted solution]

Also have a look at this Helpx articles :- 

Link 1:- https://helpx.adobe.com/experience-manager/using/querying-persisting-cq-data-mysql.html

// Querying and Persisting Adobe Experience Manager data into MySQL

    Discusses how to create an Adobe Experience Manager application that is able to query data from MySQL as well as persist data back to the database. This article creates an OSGi bundle that uses the JDBC API to query and persist data. In addition, discusses how to invoke an OSGi bundle operation from the client web page.  

Link2:- https://helpx.adobe.com/experience-manager/using/datasourcepool.html

// Injecting a DataSourcePool Service into an Adobe Experience Manager OSGi bundle

   This article talks about how to create an Experience Manager application that is able to query data from MySQL as well as persist data back to the database. This article creates an OSGi bundle and injects a DataSourcePool into it. In addition, discusses how to invoke an OSGi bundle operation from the client web page.

Video :- https://youtu.be/yYo1epoZp_4

I hope this would help you. 

~kautuk