FlexSim linking with Oracle database

Question

question

Wang Yang asked Oct 09 2017 at 3:23 PM Ben Wilson converted comment to answer Oct 18 2017 at 3:19 PM

FlexSim linking with Oracle database

Background

Aim:just with one click to import and visit oracle library.choose aim data and write automatically into global table
The test condition for data quantity from dozes of thousands to million in library

Test situation:

We equip ODBC data source locally and visit library in below ways

dbusername("CSN","CSN"); 
dbopen("CIGflexsim","Select * From MES.MachineMenue",0); 
dbsqlquery("Select * From MES.MachineMenue WHERE MachineID ='15A01' OR MachineID ='16B01'");

The whole FlexSim interface is blocked when executing dbopen(). We guess the reason is too large data quantity.

Software Version:

FlexSim 17.0.1

oracle

· 4

Ben Wilson ♦♦ commented · Oct 09 2017 at 6:18 PM

@wang.yang,

We guess the reason is too large data quantity.

Have you tested on a smaller data set to see if this is the case?

0 ·

Wang Yang commented · Oct 16 2017 at 3:39 AM

@phil.bobo @Ben Wilson

We have hundreds of thousands pieces of data in the database(such as Oracle data type ). We would like to know how FlexSim can READ and WRITE the data in real-time?

This question is very important to us.

Thanks~

0 ·

Mischa Spelt Wang Yang commented · Oct 16 2017 at 9:28 AM

@steven.hamoen once used the Oracle C++ drivers to directly talk to an Oracle-database. This is much faster than using ODBC and allows you to use Oracle-specific features, however it requires you to do some C++-coding. Perhaps Steven can tell you more about this?

1 ·

Wang Yang Wang Yang commented · Oct 16 2017 at 10:48 AM

@Mischa Spelt @steven.hamoen

Thanks~Thanks~I'll give feedback to our engineers to test it.And I'm looking forward to Steven response.

hi steven,Can you give me some ideas? Thanks~

0 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2017-10-16T15:18:00Z

Steven Hamoen answered Oct 16 2017 at 3:18 PM

Hi @wang.yang I've used the Oracle OCCI. I created a seperate dll with functions that I wanted to use and included the Oracle dll's in that dll. Next I loaded that dll with the LoadLibrary function in my Flexsim dll and used a interface class that I defined in the first dll to access the oracle functions.

The reason for doing it this way was that the Oracle DLL's are all build with dynamic linking (compile option MD/MDd (meaning they require all kinds of dll on the system where it is installed) and Flexsim dll's are build with static linking (compile option MT/MTd).

So I got it working and it works very well concerning speed and available options, compared to the ODBC route, but it took quite some time to figure everything out.

· 1

question