Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
JonathanECN

New Member
Registered:
Posts: 7
Reply with quote  #1 
I wish to access my companies database but it is using MySQL. We have no intention of changing that to use another engine because the database is already integrated with other systems.
Would it be possible to get data from the MySQL database? Does anyone have any experience with this?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
Just create an ODBC connection and you can access any ODBC database you like.
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
JonathanECN

New Member
Registered:
Posts: 7
Reply with quote  #3 
I have created an ODBC connection using ODBC Data Source Administrator but the connection does not appear in the Metastorm designer to be used. How should I create the ODBC connection?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
Select the 'Connection' icon from the component list in the home ribbon. Select the type as ODBC, and select your ODBC connection made to your database.

Note that this needs to be set up identically on the Designer PC as well as the Engine PC if different.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
JonathanECN

New Member
Registered:
Posts: 7
Reply with quote  #5 
Thank you!
0
JonathanECN

New Member
Registered:
Posts: 7
Reply with quote  #6 
Unfortunately I am now getting an error saying "The specified DSN contains an architecture mismatch between the Driver and Application". I have setup the DSN using the odbcad32.exe.
Any suggestions will be greatly appreciated.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #7 
The designer needs a 64 bit connection. The engine needs a 32 bit connection. Sorry I forgot that bit.
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #8 
That is assuming a 64 bit OS
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
JonathanECN

New Member
Registered:
Posts: 7
Reply with quote  #9 
How do I provide two different connections to accomodate for this?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #10 
You need to create a 32 bit ODBC DSN, and a 64 bit one, with identical settings.

You'll have to look up how to create them according to your OS, as it is not Metastorm dependent.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!