topic Re: Does SAS VIsual Investigator 10.6 supports other databases for scenarios? in Fraud, AML and Security Intelligence

Does SAS VIsual Investigator 10.6 supports other databases for scenarios?

Harsh_Vira — Wed, 01 Apr 2020 06:45:32 GMT

Hello All,

I have worked on SAS VI 10.2 where it supported only the PostgreSQL database for the scenario tables on which you can run the scenario rules and generate alerts.

I want to know if it is possible to use another database for the scenario tables eg. MySQL ?

All help is appreciated.

Thank you

Re: Does SAS VIsual Investigator 10.6 supports other databases for scenarios?

Mohammed_sadeh — Wed, 01 Apr 2020 08:12:35 GMT

Hi Harsh,
Yes, My SQL is supported in SAS VI 10.6 also Supported databases are PostgreSQL, Oracle
(versions 11x and 12x), DB2, Teradata, SQL Server. you can import any table from these databases.
also, you can import files (e.g.: CSV files and Excel file ) directly to SAS VI.