​@justins Lucid Software does not currently have a direct Oracle integration. However, you can repost this under Product Features. That way if enough people vote it up, then it could be included in a future release.

​@aparrish Thanks for the reply and your willingness to help. I’m not as interested in integrating with Oracle as much as I am importing Oracle views (i.e. schema, views, columns, column attributes, etc.) using Lucid’s ERD capability. 

Let me know if I need to provide more context and maybe I can come up with a sample of what I’m trying to do.

Hi ​@justins, 

Thank you for your post! You can import your data from Oracle by following these directions: 

1. Open the Shape Library Manager by clicking More shapes at the bottom of the shape menu.
2. Search for the “Entity Relationship” shape library.
3. Click the checkbox next to “Entity Relationship”.
4. Select Use selected shapes.
5. Click Import from the Entity Relationship shape library.
6. In the import menu, select the Oracle. 

   

    

7. Click Copy to Clipboard to copy the query.
8. Paste and run the query on your database.
9. Select Next.
10. Click Choose File to Import your .CSV, .TSV, or .TXT file. 
    • Alternatively, copy and paste the query results in the open text area.
11. Click Import.   

Let me know if this helps!

Thanks ​@Kelsey Gaag for the directions. Unfortunately, this still only helps with the import of Oracle Tables rather than Oracle Views. I was hoping someone had taken the Lucid query (mentioned in your 7th and 8th steps) and converted it to return View schema.

However, I did find a work around.

In my Oracle editor (PLSQL Developer) I found a way to export the view schema that I needed. Some copy/paste work - and I had the view schema formatted like the csv file resulting from the Oracle query. I imported the csv and voila!

Hi ​@justins, 

Thank you for the reply! I am glad you were able to find a workaround to the issue. I apologize that there wasn’t a native way to do this, I think that this would be a great addition to our product. You can add this as an idea in our Product Feedback section if you would like for this to be a feature. For more information on how our feedback is collected check out this community post: