Skip to main content
M
motoyay3833
February 13, 2023
Question

I would like to integrate Appain'DB to MS Access'DB.

  • February 13, 2023
  • 3 replies
  • 0 views

Hi, everyone

I would like to integrate Appain'DB to MS Access'DB.
In order to do it, I am tyring to create RPA Robot that excutes JDBC to read or write to Access'DB by costum Java code.

If you have better idea or know how to create RPA Robot that excutes JDBC to read or write to Access'DB, could you tell me about it?

Thank you.

3 replies

achutaharshavardhanv6069
achutaharshavardhanv6069
February 13, 2023

Hi [mention:f230ca2f70fd46c69ade4c1fdbb22398:e9ed411860ed4f2ba0265705b8793d05] Can you please elaborate your use case.

M
motoyay3833Author
February 13, 2023

Hi, harshavardhanv

My MS Access has data table below in it's DB.

■Table1
ID | Name | e-mai
---|-------|--------
1 | name1 | e-mai1
---|-------|--------
2 | name2 | e-mai2

I created CDT below in Appain.

■CDT1
ID | Name | e-mai
---|-------|--------
1 | name1 | e-mai1
---|-------|--------
2 | name2 | e-mai2

I would like to import Table1 into CDT1.
But, I cant't find plug-in, activities, or action which develops this.

Therefore, I am trying to create RPA Robot that imports Table1 into CDT1 in custom java code.

stefanhelzle0001
stefanhelzle0001
Brainy
February 13, 2023

I think the easiest way, is to create a web API in Appian that you can send the data to.

Terms & ConditionsAccessibility statement