MS Access database connection in AEM | Community
Skip to main content
A
admina26728807
Level 2
March 27, 2017
Solved

MS Access database connection in AEM

  • March 27, 2017
  • 2 replies
  • 1235 views

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

Thank in Advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by kautuk_sahni

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

2 replies

MC_Stuff
MC_Stuff
Level 10
March 28, 2017

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
Community Manager
kautuk_sahniCommunity ManagerAccepted solution
Community Manager
March 28, 2017

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

Kautuk Sahni
Terms & ConditionsAccessibility statement

Loading footer...