Project is urgent, need to deliver results in a short time, new team members, the database design is too low, it is difficult to understand the relationship between the database table structure, in order to enable new colleagues to better understand the database table structure, deliberately using PowerDesigner to Oracle, MySQL database reverse generation of physical diagrams, Concept map, hope to bring new colleagues to help, better improve the development efficiency
I. Oracle ODBC Data Source Configuration
1. Download the driver package
Base pack: Instantclient-basic-windows.x64-12.1.0.2.0.zip
ODBC Package: Instantclient-odbc-windows.x64-12.1.0.2.0.zip
: http://www.oracle.com/technetwork/topics/winx64soft-089540.html
Baidu Network disk: Http://pan.baidu.com/s/1i5o9zFn
2. Decompression and Installation
Unzip the above two packages, put the extracted files in the same directory (merge), note that 2 packets after the decompression of all the files must be placed in a directory, assuming that the C:\job\instantclient_12_1
Open cmd with administrator privileges, enter the directory, and run Odbc_install.exe.
3. Configuring the ODBC Driver
Set up-about--management tools,
Click "Add"
After the test connection is successful, you can use ODBC to connect to the database
Note: Not successful, it is probably the wrong version
WINDOWS10 Oracle ODBC installation configuration